This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
If I were to enter any number in a textbox on a form and is equal to any values from D12:I36, I want it to return the coresponding value in column B and the corresponding row value in D7:I7. For instance, if I type 225-01-0899 this is equivalent to the value found in F16 therefore it would return the values found in B16 and F7. How would I go about this?
Below is the link...
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Excel 365 Pro Plus with Power Query.
Find row and column header of a Table value.
No formulas, no VBA macro.
Major upgrade to Excel 365 usage needed.
https://www.mediafire.com/file/1t3nbb47xshrwri/01_08_22a.xlsx/file
Please refer to HerbertSeidenberg-6295's reply.
Any issues, you could post back.
This would be easier except the users only know the Table value. They don't know anything about the row and column header.