LinkBack URL
About LinkBacks
Alac61 
This should solve your problem:
Formula:
=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),""))
This should solve your problem:
Formula:=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),""))
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks