| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to stop index match returning data where lookup cell empty
Try this:
=IF($A55="","",INDEX(Surname,MATCH($A55,DOB,0))) Hope this helps. Pete On Jan 8, 2:55*pm, Diddy wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to stop index match returning data where lookup cell empty
Maybe
=IF(A$55="","",INDEX(Surname,MATCH($A55,DOB,0))) Mike "Diddy" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to stop index match returning data where lookup cell empty
Thank you Pete,
Just right - yet again! -- Deirdre "Pete_UK" wrote: Try this: =IF($A55="","",INDEX(Surname,MATCH($A55,DOB,0))) Hope this helps. Pete On Jan 8, 2:55 pm, Diddy wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to stop index match returning data where lookup cell empty
Thanks Mike,
Exactly what I needed :-) -- Deirdre "Mike H" wrote: Maybe =IF(A$55="","",INDEX(Surname,MATCH($A55,DOB,0))) Mike "Diddy" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
