Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Using Part of a Text
Hello,
I have three tabs: Team Track Raw Data, Commitments Data and Commitments Chart. Raw data looks like this: Name Tot Prem Rec AAAAA, John Doe $59 $616 3 I want Commitments Data to search Track Data based on first names, i.e. John and bring back the number in the 4th col, i.e. 3. So, Commitments Data will look like: Name Rec John 3 I will chart John's Rec of 3 in Commitments Chart. Thank you for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Using Part of a Text
=VLOOKUP("*"&A2&"*",'Track Data'!A:D,4,0)
"Rod" wrote: Hello, I have three tabs: Team Track Raw Data, Commitments Data and Commitments Chart. Raw data looks like this: Name Tot Prem Rec AAAAA, John Doe $59 $616 3 I want Commitments Data to search Track Data based on first names, i.e. John and bring back the number in the 4th col, i.e. 3. So, Commitments Data will look like: Name Rec John 3 I will chart John's Rec of 3 in Commitments Chart. Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup a category for a part that contains a start and end value | Excel Worksheet Functions | |||
Multi Part Lookup | Excel Discussion (Misc queries) | |||
2-part LOOKUP...t'were it possible? | Excel Discussion (Misc queries) | |||
Part Number Lookup | Excel Worksheet Functions | |||
Matrix Query Part II - lookup value | Excel Worksheet Functions |