I know I will kick myself for this but I have struggled with this for a while now. I am not that great in vlookup or even if that is what I need to do.
Here is what I am looking to do: ( i have attached the example as a file also!)
DATA TAB = Long list of info data to work from
Name Address 1 City State Zip Tech
1005 XXXXXX XXXXXX XXXXXX XXXXXX Bob
1012 XXXXXX XXXXXX XXXXXX XXXXXX Gary
1036 XXXXXX XXXXXX XXXXXX XXXXXX John
1050 XXXXXX XXXXXX XXXXXX XXXXXX Dave
1060 XXXXXX XXXXXX XXXXXX XXXXXX Mike
1070 XXXXXX XXXXXX XXXXXX XXXXXX Lonnie
1080 XXXXXX XXXXXX XXXXXX XXXXXX Bob
1090 XXXXXX XXXXXX XXXXXX XXXXXX Gary
1101 XXXXXX XXXXXX XXXXXX XXXXXX John
1102 XXXXXX XXXXXX XXXXXX XXXXXX Dave
1103 XXXXXX XXXXXX XXXXXX XXXXXX Mike
1104 XXXXXX XXXXXX XXXXXX XXXXXX Lonnie
1106 XXXXXX XXXXXX XXXXXX XXXXXX Bob
LOOKUP TAB = List of unique items that I need to find out the tech.
Item # Tech
1005 ?
1012 ?
1070 ?
1080 ?
1104 ?
1106 ?
1107 ?
1111 ?
1119 ?
1182 ?
1198 ?
1200 ?
1304 ?
I just nned to have a formula that I can copy down the list where TECH is so that it finds the item and returns the TECH info.
Any help will be greatly appreciated.
Bookmarks