aryanaveen
Board Regular
- Joined
- Jan 5, 2015
- Messages
- 104
Hi All,
Please help me with below
=IFERROR(VLOOKUP(VALUE(B17), 'Technology Charge'!A:B, 2, FALSE), "Not Required")
I am using above formula in excel 2010 where it works fine, Value(b17) picks the value in cell B17
But when I use the same formula in excel 2013 this formula doesn't work, Value(B17) will be considered as "B17" and not the value in cell.
Please help
Please help me with below
=IFERROR(VLOOKUP(VALUE(B17), 'Technology Charge'!A:B, 2, FALSE), "Not Required")
I am using above formula in excel 2010 where it works fine, Value(b17) picks the value in cell B17
But when I use the same formula in excel 2013 this formula doesn't work, Value(B17) will be considered as "B17" and not the value in cell.
Please help