Sep 29 2021 08:12 PM
What function and formula do I use to generate the desired answer.
If location cell B3 = Aus, and cell B4 = Use 1, then answer cell will display Group 1
If location cell B3 = NZ, and cell B4 = Use 4, then answer cell will display Group 3
If location cell B3 = Aus, and cell B4 = Use 4, then answer cell will display Group 2
I have created a table to incorporate vlookup function.
Thanks
Sep 29 2021 08:41 PM
@tikitour In it's roughest form that would be:
=INDEX($B$11:$C$14,MATCH(B4,$A$11:$A$14,0),MATCH(B3,$B$10:$C$10,0))
You could make it easier to write, read and maintain if you would replace all the range references by named ranges.
Sep 29 2021 10:39 PM
Solution@Riny_van_Eekelen Perfect, it has worked, thank you, I would never have got that on my own.
Sep 29 2021 10:39 PM
Solution@Riny_van_Eekelen Perfect, it has worked, thank you, I would never have got that on my own.