VLOOKUP question....

[Jaimee001]

I have an excel workbook. Sheet 1 is a data tab and sheet 2 has the fee revenue ( I named it a lookup table). I want to move the fee revenue to a column in the data sheet. I'm using a VLookup function and obviously it's not working.

The link to the example is [pre]http://speedy.sh/Pnbnn/Example-of-vlookup-for-Chandoo.xlsx[/pre]

Not sure if there is another formula to use.....my brain hurts from researching this online.

I'd appreciate any help.....Thanks in advance..Jaimee

 

[Hui]

Jaimee

I think your formula should be

=VLOOKUP(A2,'product fee look up table'!$A$2:$B$9,2,TRUE)

This will lookup the value in A2 in the first column of the table at

'product fee look up table'!$A$2:$B$9

and return the corresponding value from the second column of that table

 

[Jaimee001]

Thank you Hui,,you are a most excellent excel ninja....I totally had that vlook up backwards....made it more complicated than it needed to be....Thank you!!!!!