experts, I have the following vlookup and need to modify it.
I need to add a LIKE in the table array part.
W17 is a number but the issue is that in the table array it is a number and text and I need to match, I guess on if the numbers are "like" and dont pay attention to the letters. Example: W17 = 2.1 and in the table array it is 2.1(a). I need to match on 2.1
Let me know if you have any questions. I hope it is clear enough.
=VLOOKUP(W17,'[Survey Workbook.xlsm]BU Matrix'!$B$1:$C$63,2,FALSE)