VLookup referring to a dependent list not returning value

[LyndseyLeeVA]

Hi all

I'm creating a despatch note for a client. On the Front worksheet it has a number of columns, The first Column is a product Category (Simple DV list). Then in 4th Column the client selects the product they wish to despatch, this was created using a dependant drop down list, in the subsequent columns I need it to return the weight of the item in column 5 and Product code in column 3 once a product is selected. I'm desperately trying to remember how I've done this in the past and I thought it was via VLOOKUP but whenever I try nothing is returned from the table array in a separate tab.

Any idea's where I'm going wrong Please?
thank you in advance.

[Pete_UK]

Rather than us making stabs in the dark, as it could be any number of reasons, it would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work in this forum.

Hope this helps.

Pete

[LyndseyLeeVA]

Thanks Pete.... Hope this works

[dosydos]

when using a VLOOKUP formula the first column of the range needs to have what you are looking for. Your original formula range was from A:E. Product isnt in column A. So you need to change your vlookup to start with Column B as shown below

=VLOOKUP(G32,Products!B2:E88,2,FALSE)

as for the other columns just change the col index number accordingly.
Weight
=VLOOKUP(G32,Products!B:E,3,0)

[LyndseyLeeVA]

Thank you Dosydos, OMG I'm such an idiot! I knew it would be something simple. I blame baby brain! Appreciate the time you took to help me thank you.