Multiple if and vlookup

[Alac61]

In my worksheet I am trying to enter a formula so that I can auto load cell E20
If B20 cell is not blank
IF value of cell F9 = “R” use vlookup to retrieve value from column 3 of ‘Price list’ work sheet
But If value of cell F9 = “W” use vlookup to retrieve value from column 5 of ‘Price list’ work sheet
I have tried the following formula but don’t think it is correct for what I need..
=IF(B20>" ",(=IF(F9="R",(VLOOKUP(B20,RetailPrice,3,FALSE))," ") =IF(F9="W",(VLOOKUP(B20,RetailPrice,5,FALSE))" ")
Can someone suggest a solution or help fix the syntax of the formula?

[ROHAN999]

=if(b20>0,if(f9="r",(vlookup(b20,a:z,3,0)),if(f9="w",(vlookup(b20,a:z,5,0)," "))

unable to download your workbook,,,so on suggess sending this plz try

[ROHAN999]

=if(b20>0,if(f9="r",(vlookup(b20,a:z,3,0),if(f9="w",(vlookup(b20,a:z,5,0)," "))

[Motu040602]

I would have gone this way

[newdoverman]

This should solve your problem:

=IF(AND(B20<>"",$F$9="R"),VLOOKUP(B20,'Price list'!$B$5:$F$52,3,0),IF(AND(B20<>"",$F$9="W"),VLOOKUP(B20,'Price list'!$B$5:$F$52,5,0),""))

[Alac61]

This appears to work when selecting a populated product from the from box. But returns #NA in the Unit Price (column E) if there is no product selected to load the Unit Price field.

[Alac61]

Thank you newdoverman. Your suggested formula appears to have done the trick. It will take me a while to learn exactly how it does what it does. I appreciate all of the help and suggestions from those who have replied to this thread. Many thanks.

[Motu040602]

Sorry, didn't account for that. This one correct that.

[newdoverman]

Thank you for the feedback.

This formula breaks the problem into two parts each of which satisfy 2 conditions that being B20 not blank and if F9 is an R or W. The AND functions says that everything between the () must be true for the formula to return the TRUE argument otherwise the FALSE part kicks in. If neither is satisfied, "" is the result.