Data:
AB C D E F
Formula:
=INDEX(B4:B14,MATCH(B22,E4:E14,0))
Works: B22 was set to AleX Hog and hence the formula returns AAAA correctly.
Problem:
Match seems to work only if the range column is known and specified, in this E4:E14. I initially coded it is as ranging from C4:F14 meaning it could be found in column from B:F. That does not work. I tried using concatenation in match parameter(C4:C1&D4:D14&E4:E14). The results with or without concatenation are the same (N/A).
Objective:
Extend the formula to search through B4:E14 (potentially B2: M100) and return vendor names from column B.
Thanks & Regards,
anwer
AB C D E F
1 | A | Chris Tirk | Jus Waycraft | ||
2 | B | ||||
3 | C | Banya Blite | T Ginder | Derick Q | |
4 | Z | Jeanne King | Alex Darmanin | B Rhymes | |
5 | Q | Andrew Holm | Joey Bishop | ||
6 | P | Jacob Kaiser | Amar Bell | Rolf Tampero | |
7 | D | ||||
8 | XXXX | Sueer Grossman | Kim Fhoherty | Sam BasKoni | |
9 | YYYY | Handen Ball | |||
10 | AAAA | David Bloward | Deni Zacmak | AleX Hog | Pete Marlan |
11 | ZZZZZZ | Rob Garnuhar |
Formula:
=INDEX(B4:B14,MATCH(B22,E4:E14,0))
Works: B22 was set to AleX Hog and hence the formula returns AAAA correctly.
Problem:
Match seems to work only if the range column is known and specified, in this E4:E14. I initially coded it is as ranging from C4:F14 meaning it could be found in column from B:F. That does not work. I tried using concatenation in match parameter(C4:C1&D4:D14&E4:E14). The results with or without concatenation are the same (N/A).
Objective:
Extend the formula to search through B4:E14 (potentially B2: M100) and return vendor names from column B.
Thanks & Regards,
anwer