Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing 2 cells using vlookup | Excel Discussion (Misc queries) | |||
Vlookup using Colored Cells | Excel Discussion (Misc queries) | |||
Vlookup value between 2 cells | Excel Worksheet Functions | |||
Vlookup? Referencing cells? | Excel Worksheet Functions | |||
How do you return the sum of two cells in a vlookup? | Excel Worksheet Functions |