Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 1 number to 1000's and returning corresponding name
I have an excel file that now contains 37,000 + lines of entry on a dog breed
column A = name column B = Reg. Nr column C = M/F Column D = (currently Blank) but represent the Sire Column E = Sire's Reg Nr Column F = (currently Blank) but represent the Dam Column G = Dam's Reg. Nr If say at row 100 -- dog XYZ has the sire with the Nr = 1234567 (in E) I need column D - to compare that number in E100 with ALL those in B and return the name(in D100) from A where the matching Nr is found in B eg.. A B C D E 100 Sheila 3214 fem 1234567 120 Bob 6578 male 150 Toska 98765 fem 200 Millie 87654 fem 270 Duke 1234567 male 510 King 32768 male 766 Butch 8769 male D100 must now return the name "Duke" I don't know what command to use to do this with... or how ... Thanks and regards Malcolm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing columns and returning max value | Excel Discussion (Misc queries) | |||
comparing two lists and returning value from different column | Excel Worksheet Functions | |||
Comparing databases and returning values | Excel Worksheet Functions | |||
Comparing text and returning boolean values | Excel Discussion (Misc queries) | |||
Help comparing data and returning information... | Excel Worksheet Functions |