I have a spreadsheet of several thousand named items (in column B) with values associated with them in column A). The "name" field is a string of several alternative names for the item.
I have a list of ~50 items that I am trying to find the values for. Each uses one of the alternate names.
What I want is a function that will return the associated value in column A when one of my shortlist names is found.
For example, my big spreadsheet looks like:
A B
1 dallas, DFW. 12345
2 Atlanta, ATL, 23456
3 Boston, BOS, 34567
4 Chicago, CHI, 45678
5 Los Angles, LA, LAX, 56789
And my list looks like
Atlanta
CHI
I want the output to look something like:
Atlanta 2
CHI 4
Is the feasible? IT seems like there should be a way to do it....
Thanks in advance
Bookmarks