Concatenate two strings use it for Vlookup

[Ajaysimha]

Hi,

I am trying concatenating two Strings and use the result of Concatenate as look up value in vlookup function

The result in #NA

I am using VLOOKUP(CONCATENATE(A1,"to",B1),H1:I3,2,FALSE) in D9


A1 and B1 are Stings (Text)

[Pete_UK]

You need to put a space either side of "to", i.e.:

=VLOOKUP(CONCATENATE(A1," to ",B1),H1:I3,2,FALSE)

Also, you need to have the same spelling - Nager or Nagar? Change one of them.

Hope this helps.

Pete

[visha_1984]

try this one

Please Login or Register  to view this content.

[Ajaysimha]

Thanks pete

[Ajaysimha]

Thanks Visha