| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup value in other sheet - return coresponding value
Hi,
I need to : - Take a value on the same row as the formula - Look-up that value on another workbook / worksheet - Return a value in on the same row as the value in the other sheet Can this be done ? Regards Michael |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup value in other sheet - return coresponding value
Think VLOOKUP or INDEX/MATCH would be 2 usual ways ..
Try 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 --- "SalmatMikeG" wrote: Hi, I need to : - Take a value on the same row as the formula - Look-up that value on another workbook / worksheet - Return a value in on the same row as the value in the other sheet Can this be done ? Regards Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| looking for another same value cell in a range and returning a coresponding value | Excel Worksheet Functions | |||
| Lookup and return | Excel Worksheet Functions | |||
| How do I return entire rows in a lookup of one sheet to another? | Excel Worksheet Functions | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Hybrid Mode
