VLOOKUP using 2 Cells
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? |
VLOOKUP using 2 Cells
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? |
VLOOKUP using 2 Cells
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? In article , 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? |
VLOOKUP using 2 Cells
=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 Singapore http://savefile.com/projects/236895 xdemechanik --- |
VLOOKUP using 2 Cells
=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. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 04:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com