Translating an XLOOKUP formula from another user.

[EddieD]

Hi everyone.
I am trying to translate what an XLOOKUP formula is doing - written by a user who is no longer with us.
I researched about the XLOOKUP function, but something is stumping me - and that's the Lookup Array, and the Return Array. It's not a traditional array.

I thought that Inventory was a sheet that this formula was referring to - but there are no hidden sheets by this name. Can anyone tell me what Inventory! is referring to? My hunch is that it is a named set of cells. How can I found out what Inventory! is referring to?

Thank you all.
The formula is below:

=XLOOKUP(B3,Inventory!A:A,Inventory!DR:DR,"",0,1)

 

[Fluff]

Inventory! is a sheet, although it may be very hidden, check the properties window in the VB editor.

 

[EddieD]

Inventory! is a sheet, although it may be very hidden, check the properties window in the VB editor.

Thank you I will give this a shot.

 

[Fluff]

Ok

 

[EddieD]

Thank you - yes this in fact was the case - a very clandestine sheet.

 

[Fluff]

Glad it's sorted & thanks for the feedback.