Need help with vlookup function

[BIGTREV]

Hi,

I am having difficulty with VLOOKUP on the attached workbook.

Cell D7 contains a dropbox which selects from K4:K36, in cell F7 I want VLOOKUP to get the corresponding data from L4:L36 but am not getting the correct reply.

I have entered =VLOOKUP(D7,SUPPLIER_DETAILS!$K$4:$K$36,2,FALSE) and I know in another workbook this works very well but not here.

I have put a space before the calc in the cell for ease of keeping the info ready for correction.

Where am I going wrong?

The cells with red fill are simply reminders to enter relative data.

Regards.

[ragavan.sridar1]

Check this out..

=VLOOKUP(D7, $K$1:$L$9, 2,0)

[ragavan.sridar1]

Check this out..

=VLOOKUP(D7, $K$1:$L$9, 2,0)

[rcm]

in this case there is a range named SUPPLIER_DETAILS, so this should work

Please Login or Register  to view this content.

[rcm]

in this case there is a range named SUPPLIER_DETAILS, so this should work

Please Login or Register  to view this content.

[BIGTREV]

Thanks for all replies - I can see it now, after a long day I must have been going number blind.