Finding Colum Name

[projectgregory]

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.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=XLOOKUP(F10,XLOOKUP(D10,B4:B6,D4:G6,"",1),D3:G3,"")

 

[projectgregory]

Hi & welcome to MrExcel.
How about

=XLOOKUP(F10,XLOOKUP(D10,B4:B6,D4:G6,"",1),D3:G3,"")

Thankyou, but do you know of a way of doing this on older versions of Excel without xlookup.

 

[MountainFog]

=INDEX($D$3:$G$6,1,XMATCH($F$10,CHOOSEROWS($D$3:$G$6,XMATCH($D$10,$B$3:$B$6,-1))))

 

[Fluff]

@MountainFog xl2021 does not have some of those functions.

 

[Fluff]

do you know of a way of doing this on older versions of Excel without xlookup.

It would have helped if you had said that at the start.

 

[Fluff]

How about

=INDEX(D3:G3,MATCH(F10,INDEX(D4:G6,MATCH(D10,B4:B6,1),),0))

 

[projectgregory]

How about

=INDEX(D3:G3,MATCH(F10,INDEX(D4:G6,MATCH(D10,B4:B6,1),),0))

Thankyou, I will try that out shortly.