pdvsa
asked on
Vlookup and Like
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 )
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
ASKER
HI, thanks for the response...that didnt seem to do it though. I now get a #N/A.
I was thinking that I would need the &"*" part in the table array?
thank you for the help...
I was thinking that I would need the &"*" part in the table array?
thank you for the help...
What are your data like in the lookup array table?
Can you give some example? Do they always have letters in parentheses ?
Can you give some example? Do they always have letters in parentheses ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you... That was it
=vlookup(w17&"*",lookup range etc