Hello,
I am trying to set up an inventory table with a designated cell to search for the location of an item (as shown in the example below)
A1 A2 A3 A4 B1 B2 B3
1
2
3
4
5
...
Location: *****
Item: *****
As I input a value into the cell to the right of "item", the location of the item is updated in the cell to the right of "location" (with the location being the column header)
The formula that I am currently using is:
=IFERROR(INDEX(Table2[[#Headers],[174 A1]:[DOCKET]], SUMPRODUCT(MAX((Table2[[174 A1]:[DOCKET]]=A23)*(COLUMN(Table2[[#Headers],[174 A1]:[DOCKET]]))))-COLUMN(Table2[[#Headers],[174 A1]])+1),"")
The problem that I am running into is that some of the values that I am searching for are only partial matches to what is in the cell in the table. Is there a way to use a wildcard with A23?
I have tried A23&"*" but I'm not sure how else to solve this problem.
Any help would be appreciated and if my explanation is too confusing I can try to clarify.
Thank you!!!
Bookmarks