How to stop index match returning data where lookup cell empty

D

Diddy

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
 
P

Pete_UK

Try this:

=IF($A55="","",INDEX(Surname,MATCH($A55,DOB,0)))

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index Match & #values 0
Index Match to add employee number 2
Index Match to ignore blank cells 0
How to summarize copied data 2
Split Data Series (Lookup, Index, Match references) 1
First row where a cell is zero 2
Is it possible to pick up formatting from range using index match? 4
VLOOKUP not working with data from PeopleSoft 3

Top