Excel: VLOOKUP a concatenated value

Hi All,

How can I VLOOKUP a value that is a concatenation of two other values?

=VLOOKUP(A2&B1,DATA,2,0)

Open in new window

LVL 2
detox1978Asked:
Who is Participating?
 
detox1978Author Commented:
Sorted it.  I was using a number, so had to use INT()

=VLOOKUP(INT(A2&B1),DATA,2,0)

Open in new window

0
 
NorieVBA ExpertCommented:
If the result of the concatenation returns a value that is in the lookup range then the VLOOKUP should work.
0
 
detox1978Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.