Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup formulas
I would like to create a lookup formula that will return info in the cells
adjacent to the cell with the info in the lookup, is this possible? -- cquatro |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup formulas
A vlookup, returns values to the right in a range of the found cell,
=vlookup(a1, C1:D5, 2, false) returns the value one column to the right of the found cell, which is the 2 argument. -- David "cquatro" wrote: I would like to create a lookup formula that will return info in the cells adjacent to the cell with the info in the lookup, is this possible? -- cquatro |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup formulas
You could use either a VLOOKUP or INDEX/MATCH for the job in the formula cell
Browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "cquatro" wrote: I would like to create a lookup formula that will return info in the cells adjacent to the cell with the info in the lookup, is this possible? -- cquatro |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup formulas
Sure thing,
Without a bit more information on your ranges, and what you're trying to get back, though, all I can really recommend to you is that you look up Vlookup and Hlookup in the help files. Do be aware that to get an exact match, you will want to add the ,False argument to the end of the formula though. (This will make more sense when you review the help file.) HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca cquatro wrote: I would like to create a lookup formula that will return info in the cells adjacent to the cell with the info in the lookup, is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I highlight all lookup formulas in a worksheet in one shot. | Excel Discussion (Misc queries) | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |