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

"RoadKill" wrote:

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?