LinkBack URL
About LinkBacks
The following code looks up a price from a price list. If a price is unavailable, in place of an error message, I want the cell to display "No Price".
Thanks in advance.HTML Code:
The following code looks up a price from a price list. If a price is unavailable, in place of an error message, I want the cell to display "No Price".
Thanks in advance.HTML Code:
Wrap as follows
On Error Resume Next C.Offset(0, 14).FormulaR1C1 = "=IF(RC3="""","""",IF(PriceModelWithQTY=""cycle"",VLOOKUP(RC3," & PriceListRangeName & ",14,FALSE),IF(PriceModelWithQTY=""National"",VLOOKUP(RC3," & PriceListRangeName & ",29,FALSE),VLOOKUP(RC3," & PriceListRangeName & ",32,FALSE))))" If Err > 0 Then MsgBox "No Price"" On Error GoTo 0 End If
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thank you kev
Gald it worked for you
Thanks for marking thread as solved and for the reps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks