| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return alternate value if VLookup can't find match
Hi all
I'm finding my way round the intricacies of VLookup and making some progress, but am stumped by a small problem. I have a working VLookup in a worksheet called Staff =VLOOKUP(A3,'Report data'!$A$1:$P$9999,4,FALSE) which returns a name from the Report Data sheet if it's present, and a 0 if not. However, rather than the zero I would like it to return the value of column 2 in the Staff (active) worksheet. Can this be done with a nested function or does it need VBA? All comments gratefully received! Sue JB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES | Excel Worksheet Functions | |||
| Find text in another workbook and paste if found match - VBA | Excel Discussion (Misc queries) | |||
| How to find MATCH numbers ? | Excel Worksheet Functions | |||
| is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
| Use MATCH to find position of max in 2D range? | Excel Worksheet Functions | |||
Threaded Mode
