Vlookup in 2 different cells

[hsantos]

Hi,
im trying to do the following:

i have sheet2 that has a pricelist with 3 colums A1, B1 and C1. A1 is the name, B1 is the price and C1 is an extra.

on Sheet1 i have a dropdown list that picks up the a range of cells from colum A on sheet 2. Then i use Vlookup to pick the price from sheet2 associated to the item i pick on the drop down list.

all this works fine except, cell C1 that has an extra price, i only want it to display it if i type yes in cell D1.
how would i do that?

I attached the file to have a better idea.

[PaulM100]

Try:

=IF(D2="YES",IFERROR(VLOOKUP(A2,Sheet2!A2:C4,3,0),0),"")

[etaf]

try
=IF(D2="yes",IFERROR(VLOOKUP(A2,Sheet2!A2:C4,3,0),0),"")

in C2
or if you want a zero
=IF(D2="yes",IFERROR(VLOOKUP(A2,Sheet2!A2:C4,3,0),0),0)

[hsantos]

WOW! great. thank you!

[PaulM100]

Please mark the thread as Solved if that took care of your problem. Thanks.