Populating a cell based on what the user selects from a drop down

Hi guys,

I've searched and tried differnet options but either my brain is locked up, I'm doing something wrong or I need more coffee...but I simply can't seem to make it work.

I want to populate a field in colums C based on a selection the user makes in column B. This is on the first sheet named "Build".

The user will not see the second worksheet where I have the pricing and options listed and will be locked out of editing anything on the first sheet.

It's basically going to be a sales tool so people can 'build and price' an item.

Any suggestions on how to make this happen?

I've attached a sample.

Thanks in advance!

Test.xlsx

Put this in cell C4 and copy down:

=IF(B4="","",VLOOKUP(B4,Options!$A$3:$B$12,2,FALSE))

Originally Posted by BadlySpelledBuoy

Put this in cell C4 and copy down:

=IF(B4="","",VLOOKUP(B4,Options!$A$3:$B$12,2,FALSE))

Perfect! Thank you!

I was missing the first "".

Originally Posted by judgeh59

Give this a go

Thank you as well.

When I tried this, it didn't seem to change the value in the other column.

You could also use =IFERROR(VLOOKUP(B4,Options!$A$3:$B$12,2,FALSE),"") but this wont work if you open the file in Excel 2003 or earlier.

Happy to help.


BSB.

Yeah, it's definitely strange here. I tried a couple of the empty cells with the drop down and while I can select a color, the price won't populate.

I do appreciate it though!