Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find data in adjacent cell
I have been given a excel sheet of 50+ columns 2000+ rows and all over the
place are the some 2500 names and telephone numbers and lots of rubbish - fortunately the telephone number that belongs to each name is 2 rows down in the same column. (On a row with other names and lots of rubbish) If you Look for X, Y, and H names and numbers below you can see what I mean. X-name rubbish rubbish H-name rubbish Y-name rubbish rubbish X-number rubbish rubbish H-number rubbish Y-number J-name I have a separate sheet of 400+ names I want the telephone numbers for. All of my 400 names and numbers are in the 50x2000 row sheet How can I search for X-name (out of my list) and put in the next column the number that relates to it from the 50x2000 sheet (two rows down in the same column) So I end up with; X-name X-number Y-name Y-number H-name H-number Regards Leon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
Cell data format | Excel Discussion (Misc queries) | |||
copying data to an adjacent cell | Excel Discussion (Misc queries) | |||
Vlookup for data contained in a cell | Excel Worksheet Functions | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) |