excel - how to make a cell populate data from another sheet based on dropdown selection -

i've looked , didn't example works situation.

i making pricing calculator , need have pricing populate in cells once i've selected device dropdown.

i've created source data in sheet2 column device column b msrp , column c discounted price

on sheet 1 want select device in cell b4 (already have dropdown created) , have automatically populate msrp in c4 , discounted price in d4.

i'm not familiar how use vlookup , iferror , other answers i've seen didn't explain how formulas worked enough me adapt situation.

any appreciated, thank you!

something like:

=iferror(vlookup (b4,'sheet2'!a$1:c$200,2,false)),"-")

in c4 in sheet 1 return value column 2 on range a:c in sheet 2 (i.e column b). change 2 3 in d4 value column c in sheet 2. false forces excel match values rather picking first match finds. if can't find value iferror returns -. can change c$200 cover full range of whatever in list in sheet 2.