VLOOKUP using 2 Cells

[RoadKill]

What I want is the lookup to use cells B2 and B3 when it looks up a value

Here is my formula now: =VLOOKUP($B$2&$B$3, 'Apr Sups'!$B$2:$J$13,6,0)

What am I doing wrong?

 

[Mike H]

your fromula works fine for me but bear in mind the concatenated B2&b3 will
be text so for example if B2=Cat and B3=Dog it will look for CatDog in column
B of the lookup range and return colum 6. If B2 & b3 are 2 & 1 it wont find
the number 21 in the lookup range because the 21 is text

Mike

Mike

 

[JE McGimpsey]

Hard to tell what you're doing wrong - there's nothing *inherently*
wrong with your formula, so it must be your logic.

What result are you getting, and what do you expect?

What values do you have in B2 & B3, and does any cell in 'Apr
Sups'!B2:B13 contain the concatenation of the two?

 

[Max]

=VLOOKUP($B$2&$B$3, 'Apr Sups'!$B$2:$J$13,6,0)

Maybe one of these guesses:
=VLOOKUP(TRIM($B$2&$B$3), 'Apr Sups'!$B$2:$J$13,6,0)
=VLOOKUP(TRIM($B$2&" "&$B$3), 'Apr Sups'!$B$2:$J$13,6,0)

 

[Max]

=VLOOKUP($B$2&$B$3, 'Apr Sups'!$B$2:$J$13,6,0)

Presume it's ensured that the vlookup's match col B ie 'Apr Sups'!$B$2:$B$13
does contain the concatenated strings for correct matching? You might want to
check that. Also maybe try a TRIM to clean up the concat strings if you are
getting #N/As where apparently there should be matches.