Pulling out string below certain cells using if statement

  • Thread starter Thread starter hoffman3
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

Pull text from cell with if statement 2
If Statements 1
IF Statement Help 6
Gathering Data using excel 1
How do I pull value from c8 but only if a8 = a certain value 2
=IF function, reference problem to "text strings" in Data Validati 2
Using 2 IF statements for the same cell 2
IF Statement 2

Back
Top