IF VLOOKUP Help :-)

[jpoppet]

Good Afternoon, I'm creating a very simple work that will determine stocks.

Have included a simple sample - I would like multiple cells to autofill according to a drop-down list.

ie - I selected 'Tea Bags' and the cells describing extra information will automatically fill out, gathering information from a table.

Have been trying to write my own formulars such as;

Please Login or Register  to view this content.

...having no luck however - have previously been able to do this but I'm hungry and just want to get this done now so I can go for lunch.

Any help is grateful, cheers.

Book2.xlsx

[Jonmo1]

You've used a Form Control Listbox.
There actually is no value in B4 no matter what you choose from the listbox.
Delete that, and use Data Validation instead
Highlight B4, Data - Data Validation - List
then use the =item as the source.

[ChemistB]

Alternately, if you want to use the Listbox, right click on it > "Format Control"> Cell Link B4
Then you can use this formula
with Excel 2007 up
=IFERROR(INDEX(Table1,$B$4,2),"")