Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to stop index match returning data where lookup cell empty
Hi everyone,
I've got the following formula =INDEX(Surname,MATCH($A55,DOB,0)) but I'm getting data returned when A55 is blank (end of data on summary sheet) but where DOB is not filled in on the lookup sheet. Can I add an if to make it blank? if so how? or is there a better way? Cheers -- Deirdre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match and index returning N/A | Excel Worksheet Functions | |||
Returning Data to an empty Cell | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Returning an empty cell when no data present | Excel Discussion (Misc queries) | |||
Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions |