Hi Nikki,

=IF(ISNA(INDEX($A$1:$J$30,MATCH($A1,$H$1:$H$30,0), 10)),"",INDEX($A$1:$J$30,MATCH($A1,$H$1:$H$30,0),1 0))

The above is a tested formula. You need to edit with your ranges.

Also it is actually one line but does not fit here.

Note the zero parameter at end of match formula. See help for what it does.

Regards,

OssieMac


"Nikki" wrote:

Hi,

I have a spreadsheet with the following Columns:
A = Last Names
B= First Names
C = Extentions
E,F,G are blank
H = Last Names (only a selection of colum A)
I = First Names (the corresponding first names)
J = Cell Phone Numbers

I have used the following forumla

=INDEX($A$1:$J$365,MATCH($A6,$H$1:$H$279),10)

I would like it to look in Column H and if it finds the same last name as in
Column A put the corresponding cell phone number from Column J into Column L

This works so far except if it cannot find a last name in Column H it puts
the cell phone number from the line previous until it findsa matching last
name again.

I would like it just to stay blank if it can't find the matching last name.
What can I change in my formula to achieve this?

Thanks