IF(VLOOKUP) not working

[Sandy01UK]

Hi


Looking for some help/pointers. I'm trying to combine an IF and a VLOOKUP and it doesn't seem to work!

If cell B2("LIVE MASTER TAB") contains the word/text "WEB" lookup the value in Cell E2("LIVE MASTER TAB) against Columns U:W("PRICING DATA TAB) and return the value in column W.

The formula I'm using is

=IF(B2="WEB",0,VLOOKUP(M2,'Pricing Data'!U:W,3,FALSE))

If the value in B2 Is not "WEB" I need to return a blank.

Thanks in advance

Sandy

 

[VoG]

Try

=IF(B2="WEB",VLOOKUP(M2,'Pricing Data'!U:W,3,FALSE),"")

 

[Sandy01UK]

Thanks for this it seems to work what would be the syntax to replace N/A with "no price"

Thanks

Sandy

 

[VoG]

Try

=IF(B2="WEB",IFERROR(VLOOKUP(M2,'Pricing Data'!U:W,3,FALSE),"No price"),"")

 

[Sandy01UK]

Thanks it worked a treat

Sandy