Multiple lookup table

[simonbunker1]

Hi All

I really hope someone here can help with this

I have 3 variables that i need to lookup from a table, i have looked at another post on this forum but it does not seem to give me the correct result i have also tried writting a vlookup but can only get it too work with two vaiables

please see attached sheet for an example of what iam trying to accomplish

Thank you in advance for any help you may be able to give

Regards

Simon

[NBVC]

Since you have merged cells in your table headings it makes it more difficult...

Try adding a helper row just above the table that combines the 2 row headers of rows 20 and 21. So in C16 add formula:

=LOOKUP(2,1/($C20:C20<>""),$C20:C20)&"_"&LOOKUP(2,1/($C21:C21<>""),$C21:C21)

and copy it across to R16.

Note: You can hide this row or colour the fonts to match background.

Then your lookup formula would be:

=INDEX($C$22:$R$40,MATCH(AA8,$B$22:$B$40),MATCH(Z8&"_"&X8,$C$16:$R$16,0))

[simonbunker1]

NBVC

Thank you, that was well beyond me, just one little niggle is that if type c is selected it returns N/A when it should -=0.45 or Q31 could you have another quick look,

Really appreciate your expertise

Regards

Simon

[NBVC]

It is because your C in Q20 has a leading space... delete that space and all is well

[simonbunker1]

Brilliant

Thank you so much, you have no idea how much easier you have made my life

Regards

Simon