Forum Discussion
Use results of =CONCAT(B2,", ",A2) for a Vlookup Table Array Target
I'm using a =Cocat to combine the first name and last name fields followed by a comma and space. The results are a target array for a Vlookup. I'm getting a #NA error on the Vlookup. I know that many...
mathetes The cell that needs be Trimmed contains =CONCAT(B2,", ",A2)
A2 = Last Name, B2= First Name
Did I miss a step?
Formula should begin:
=VLOOKUP(TRIM(B2&", "&A2)
If you think the spaces are in the table_array:
=VLOOKUP("*"&B2&", "&A2&"*",
Patrick2788 Thanks. It worked!