Auto complete cells after choosing data in drop down list

[leonardsway]

Hi Guys

Sorry for the long title. I need some help if anyone can answer this please

I have set up a simple spreadsheet with some drop down boxes using data validation.

What I want is to be able to choose an item from a drop down list then the cost to automatically appear in another cell. I have all the cost data on the same worksheet as the item lists. Does this make sense and if so is it possible???

Cheers

Leonardsway

[Spellbound]

Hi

It would be more helpful if you can attach a sample workbook, showing the data and the results you are trying to achieve.

spellbound

[leonardsway]

Thanks for your reply Spellbound

I have attached the file.

As you will see I have drop down boxes in column C for quantity then when the user picks a size from the drop down box in column D I want column E to self populate with a cost from the corresponding data found in Sheet 2

Does this make sense??

[sglife]

Try the attached excel file

[leonardsway]

Brilliant, exactly what I was trying to do!! Is there anyway I can get rid of the #N/A in the cells with the formula just to tidy it up a bit??

Thanks very much