| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and return the value from the look up value sheet
Dear anyone,
I have come across with vlookup funtion which i have to use it at my work. I have two sheets. Sheet 1 has charge codes and value, and sheet 2 has specific charge codes. I want look up value from the sheet 1 and table array from sheet 2 but return value is only in sheet 1 which I want . How to sort such problem since vlookup only allow me to return the value from table array sheet in normal circumstance without adding up any additional formula. Your help is much appreciated. Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
| Vlookup that does not return #N/A | Excel Worksheet Functions | |||
| How can I cause a cell to return the sheet name i.e. sheet 1? | Excel Worksheet Functions | |||
| VLookup Return Value | Excel Worksheet Functions | |||
Threaded Mode
