VLOOKUP using 2 Cells

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

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?
 
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
 
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?
 
=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)

---
 
Back
Top