| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup on more than one sheet
Is it possible to make vlookup look at other sheets for a matching value when
it does not find a value on the first sheet?? To look on two sheets I tried =IF(ISNA(VLOOKUP(C6,SHEET1!A:B,1,FALSE)),"",(VLOOK UP(C6,SHEET2!A:B,1,FALSE))) THis always returns #N/A even for values I know are present. Also I need the formula to look on sheet1, if it does not find it look on sheet 2 and if it still does not find it look on sheet3. Any ideas? Any help would be very much appreciated. Regards John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you do two Vlookup tables in one sheet? | Excel Discussion (Misc queries) | |||
| vlookup across more than one sheet | Excel Worksheet Functions | |||
| how do i use vlookup to search for a value on another sheet? | Excel Worksheet Functions | |||
| VLOOKUP from another sheet, VBA | Excel Worksheet Functions | |||
| vlookup with data on more than one sheet | Excel Worksheet Functions | |||
Threaded Mode
