Nested XLOOKUP generates #Value error

[Tommy Snoberg Soderberg]

Hi,

I'm trying to create a lookup formula to look for values in both the X and Y axis. No matter what I do I get a #value error.

I have tested to separate the two xlookups to test the cell formats etc. and both works. But when I combine them it doesn't. I'm thinking that a combination of tables and ranges might be a problem? But I can't figure it out.
The Lookup values and the lookup array are both on numbers format.

Anyone have an idea what to do?

As a side note, I have also tried to solve the problem with Index Match but it fails as well.

=XLOOKUP([@[Item ID]];ITEM_PROFILE_SE2!A:A;XLOOKUP(AWRitemSE!$AI$1;ITEM_PROFILE_SE2!$1:$1;ITEM_PROFILE_SE2!$F$2:$BE$17568))

 

[Alex Blakenburg]

Your lookup and data ranges have to match.
(untested)

=XLOOKUP([@[Item ID]];ITEM_PROFILE_SE2!$A$2:$A$17568;XLOOKUP(AWRitemSE!$AI$1;ITEM_PROFILE_SE2!$F$1:$BE$1;ITEM_PROFILE_SE2!$F$2:$BE$17568))

 

[Tommy Snoberg Soderberg]

Your lookup and data ranges have to match.
(untested)

=XLOOKUP([@[Item ID]];ITEM_PROFILE_SE2!$A$2:$A$17568;XLOOKUP(AWRitemSE!$AI$1;ITEM_PROFILE_SE2!$F$1:$BE$1;ITEM_PROFILE_SE2!$F$2:$BE$17568))

Ah!! Thank you so much!

 

[Alex Blakenburg]

You're welcome. Glad I could help.