Formula Help--XLOOKUP?

[FoodYarnNerd]

I am trying to pull in data from one table into another and cannot figure out how to make it work.

I need to look up both the Material and the Size in a different table and then pull in the value into column V (first snip). However, the table that I need to pull from has the size information running across as column headers so a VLOOKUP will not work (second snip). I was hoping XLOOKUP or INDEX-MATCH would give me what I need but I cannot seem to get any formula to work here. Am I missing something obvious?

Thanks so much for any assistance!

 

[Crystalyzer]

Place the formula below in column V

=INDIRECT("R"&MATCH(T8,$A$1:$A$3,0)&"C"&MATCH(U8,$A$1:$Q$1,0),FALSE)

 

[Fluff]

Hi & welcome to MrExcel.
Another option without volatile functions

=INDEX($A$2:$Q$100,MATCH(T2,$A$2:$A$100,0),MATCH(U2,$A$1:$Q$1,0))

 

[FoodYarnNerd]

Hi & welcome to MrExcel.
Another option without volatile functions

=INDEX($A$2:$Q$100,MATCH(T2,$A$2:$A$100,0),MATCH(U2,$A$1:$Q$1,0))

Okay, follow up question--if the table from the second snip is on a different sheet in the same workbook, how does that change what the formula should say? I tried to plug and play what I thought I should put in there and it still errored out.

I appreciate your help!

 

[Fluff]

What is the name of the other sheet?

 

[Crystalyzer]

Just replace Sheet4 with name of the other sheet and adjust range rows and cols

=INDEX($A$1:$Q$3,MATCH(T7,Sheet4!$A$1:$A$3,0),MATCH(U7,Sheet4!$A$1:$Q$1,0))

 

[FoodYarnNerd]

What is the name of the other sheet?

Sheet1 is where the table I'm trying to pull the data from into column V on HIX Report.

 

[Fluff]

In that case it would be

=INDEX(Sheet1!$A$2:$Q$100,MATCH(T2,Sheet1!$A$2:$A$100,0),MATCH(U2,Sheet1!$A$1:$Q$1,0))

 

[FoodYarnNerd]

In that case it would be

=INDEX(Sheet1!$A$2:$Q$100,MATCH(T2,Sheet1!$A$2:$A$100,0),MATCH(U2,Sheet1!$A$1:$Q$1,0))

This is still throwing an #N/A error--I've tried all my typical fixes as far as formatting the cells but it's still not pulling in the info. Is there something obvious I'm missing? (I swear I'm not a total n00b, LOL)

 

[Fluff]

Is the data on sheet1 in a structured table, or just a normal range?