projectgregory
New Member
- Joined
- Dec 1, 2023
- Messages
- 3
- Office Version
- 2021
- Platform
- Windows
Hi, I have been stumped and no matter how much searching I cant seem to find a answer.
I have a table and I want to find the column name i.e. A, B, C, D. I will start off with entering a value into D10 which is within a size range of 3 to 6 i.e. row 5 then I want to find the value in row 5 that matches the value in F10 and return the column value that number is in to cell H10.
I have managed to find the row using a sumproduct but I can't figure out how to only search that row for the size2.
Thankyou.
I have a table and I want to find the column name i.e. A, B, C, D. I will start off with entering a value into D10 which is within a size range of 3 to 6 i.e. row 5 then I want to find the value in row 5 that matches the value in F10 and return the column value that number is in to cell H10.
I have managed to find the row using a sumproduct but I can't figure out how to only search that row for the size2.
Thankyou.