Pulling out string below certain cells using if statement

H

hoffman3

Alright i have a huge list of names, cities, emails, numbers an
directory listing #'s. I want to somehow pull out all the names in th
excel sheet but the names arent' the same number of rows apart an
don't have a field identifier with them. The only consistency I coul
find is that the name is always directly below the directory numbe
which is always listed like abcd*********. So my question is, is ther
a way to do an if statement or something similar to this to say if yo
hit a directory number pull the cell above it to the right or somethin
along those lines. thanks for any suggestions.
Eric Hoffma
 
P

Peo Sjoblom

Yes, you can use OFFSET combined with MATCH or
INDEX with MATCH and offset the way you want

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top