| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup referencing more than one worksheet
Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/300...-10423159.html ....then use this formula =IF(ISNA(VLOOKUP(A1,THREED('B:C'!A1:B10),2,0)),"No t Listed",VLOOKUP(A1,THREED('B:C'!A1:B10),2,0)) "Kris W" wrote: Hi (Excel 2003) I have a vlookup formula in worksheet A, which looks up worksheet B, but I need it to look up worksheet C also - how do I do this? I also need it to say "Not Listed" instead of "#N/A" as it does at the moment... Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using vlookup when referencing text | Excel Discussion (Misc queries) | |||
| Vlookup? Referencing cells? | Excel Worksheet Functions | |||
| CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
| CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
| VLOOKUP referencing another workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
