Hi all, I'm trying to get the cells in a column to return the info from another table if an Order is ticked (with a checkbox) with the correct info for the Building type selected. Here is a screen grab that hopefully explains it far better!
so Order 2 (being selected) will show the information for Building C...
I'm ok with XLOOKUP, which is what I've tried, but not with multiple look-ups!
thanks, Ric
i finally managed to work this out (yay!!), and thought i'd share in case anyone else needs something similar...
IFERROR(XLOOKUP(XLOOKUP(TRUE,Table 1::E$3:H$3,Table 1::E$4:H$4),Table 1::A$2:C$2,Table 1::A3:C3),"-")
i only added the IfError in case no boxes are selected/checked as i hate to see the dreaded red triangular warning symbols!!
hi all, i'm sure this is possible, and this is what i've tried, but not sure if i can put an XLOOKUP in an XLOOKUP like this??!!
XLOOKUP with multiple criteria
