Vlookup incorrect or 'slightly scatty'....

[timberdog]

Hi
I am making a pricing book for picture framing (which I dabble in) and seem to have a problem with my vlookup bringing incorrect answers back to a cell. I have 4 dropdown list and a vlookup (and table) for each list. Calculations on half of the available 'dropdown' options are correct and others are returning that same answers despite having different table values.
Here is a link to my file (as I can't seem to attach) http://www.timberdog.co.uk/frame_pricing.xlsx to see if anyone can see whats wrong. It must be a simpe thing but Im damned if I can see it
For instance on the Mount dropdown list 'conservation' is the same as 'black core' but it should be at least half the cost of 'black core' All other drop-dpwns have the same inaccuracies within them.
Please help me !

 

[VoG]

You need to set the 4th parameter to false and make your lookup table range absolute

=VLOOKUP(B2, costings!A$2:D$50,3,FALSE)*E2*costings!G2

 

[Jonmo1]

Welcome to the board.


Try adding FALSE as the 4th argument in each of your vlookup formulas.

 

[Saagar]

Since the table array is not a sorted list, you will need to modify your formula from

=VLOOKUP(B4,costings!K7:P11,6)*E4*costings!F2

to

=VLOOKUP(B4,costings!K7:P11,6,0)*E4*costings!F2

 

[timberdog]

thank you to all of you. It is all working fine now.
I am going to look up about making things 'absolute' and why I need add a 'false' to argument - but thats got me out of a pickle for now !