Forum Discussion
Need help with formula
So I need a hand with sorting this out. Cell B58 and D58 are drop down menus and I have part pf the list at the bottom. I want to be about to select say "Belyando" and "Brisbane" in the lists and t...
Adrien89 A simpler approach would be to list all of the possible departure and destination locations in a lookup table, like you have started in cell B74, then use the XLOOKUP function, if it's available in your program. For example:
=XLOOKUP(1, (B58=$B$75:$B$1000)*(D58=$C$75:$C$1000), $D$75:$D$1000, 0)- I'll have to have a look at this a little later tonight as I'm not the tech savvy LOL
Adrien89 No worries 🙂
For a detail explanation of this method, check out: https://exceljet.net/formulas/xlookup-with-multiple-criteria
