Two way Lookup formula problem

[David Evans]

I've done this many times before with success, but today this is beating me. As a devout excel ninja I went to the Temple of Chandoo and studied his examples on 2 way lookups to no avail ...

I've uploaded the file for .. your entertainment .. you can all have a laugh at my stupidity!

 

[Smallman]

Hi Dave

Would this work for you. I tried to build in the flexibility I thought you were looking for.

=VLOOKUP(H5,$B$3:$F$26,MATCH($H$3,$C$2:$F$2,0)+1,1)

Change Cell H3 for the flexibility.

Take care

Smallman

 

[David Evans]

Thanks Smallman!
Appreciate your help with this - I was getting #REF errors ..... duh ...

 

[Smallman]

Hi Dave

Would you like to elaborate because it does not matter what fruit flavored numbers I put in the model above all I get is joy.

Smallman

 

[David Evans]

Hi Dave

Would you like to elaborate because it does not matter what fruit flavored numbers I put in the model above all I get is joy.

Smallman

Sorry I should have been clearer - i was getting the #REF with my attempt at the formula - your effort produced nothing but sweetness, light and joy! Thanks - it was at the end of a long day for me and I was tired ...