SimonHughes
Active Member
- Joined
- Sep 16, 2009
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
I have a simple formula =IFERROR(VLOOKUP(A42,'Sales Pricing.rdl'!$B$5:$G$1936,6,0),F42*0.8) which I am using to create a price list.
However, there are blank rows which creates the error #VALUE. What do I need to add into this formula to prevent the error message appearing?
I am using Excel 2010 on Win 7
However, there are blank rows which creates the error #VALUE. What do I need to add into this formula to prevent the error message appearing?
I am using Excel 2010 on Win 7