vlookup keeps returning #ref

[stevesunfold]

hi gents

i have a drop down list in cell b16 which then corresponds with what to bring up in the next drop down list in cell d29
this works fine

i then have this formula thanks to daddylonglegs

Please Login or Register  to view this content.

in cell c29

and then this formula in cell b29

Please Login or Register  to view this content.

but in cell b29 all i keep getting is #ref

why is this and how do i stop it
i have followed what i can with office help
and enabled iterative calculation but to no avail

basically in cell b85 is the word im looking for in cell d29
then in c85 i have qty that they come in
d85 i have the product code
and e85 i have the price

[StephenR]

In this statement you're asking Excel to look in column 3 of the lookup range which is only two columns wide (B:C)

VLOOKUP($d29,$B:$C,3,0)

[stevesunfold]

Thanks stephen
stupid me