Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=Index Problem
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index formula problem | Excel Worksheet Functions | |||
Index/Match problem | Excel Worksheet Functions | |||
INDEX PROBLEM...I THINK | Excel Worksheet Functions | |||
INDEX / MATCH problem | Excel Worksheet Functions | |||
INDEX problem | Excel Worksheet Functions |