SOLVED

Functions and Formulas, which is best

Copper Contributor

 

What function and formula do I use to generate the desired answer.

 

tikitour_0-1632971552772.png

 

 

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

2 Replies

@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. 

best response confirmed by tikitour (Copper Contributor)
Solution

@Riny_van_Eekelen Perfect, it has worked, thank you, I would never have got that on my own.  

 

1 best response

Accepted Solutions
best response confirmed by tikitour (Copper Contributor)
Solution

@Riny_van_Eekelen Perfect, it has worked, thank you, I would never have got that on my own.  

 

View solution in original post