-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
nested lookup
-
J
Multiple Layer VLOOKUP, or better alternative?
Hello All! Trying to solve the following: A purchase order is placed for a product on DATE A. (For purposes of demonstration, let's say July 1, 2022) The product has a Part Number (which can be numeric or text) within a contract number (text) within a supplier number (text) Prices for each...- JukeExcel
- Thread
- multi-layer array multi-layer lookup nested array nested array formula nested lookup
- Replies: 9
- Forum: Excel Questions
-
Two-way XLOOKUP() w/ Multiple Lookup Values (Range)
Hello excel experts, I am using a two-way XLOOKUP() to grab a range of lookup values from a dynamic column lookup. The formula I am currently using is: =SUM(XLOOKUP($C$11:$C$43,INDIRECT("'"&G$10&"'!"&"$A:$A"),XLOOKUP($D11,INDIRECT("'"&G$10&"'!"&"$6:$6"),INDIRECT("'"&G$10&"'!"&"$1:$1048576"))))...- TheMacroNoob
- Thread
- nested lookup range xlookup
- Replies: 1
- Forum: Excel Questions
-
G
Use XLOOKUP to get largest hour for a given day
Hi folks, Struggling to make the following work, mainly because the last hour is not always the same. I have 1 hour Close (col F) data for a continuous futures contract Due to when markets trade, the final hour of data is not always the same. In this case it is not always 23:00:00 time. I am...- GeeWhiz7
- Thread
- lookup nested lookup
- Replies: 3
- Forum: Excel Questions
