Thread: How to stop index match returning data where lookup cell empty
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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
Reply With QuoteReply With Quote