Hi guys
Id be grateful if you can help. Im getting a value error on this formula and I cant work out why this is the case
The Vlookup returns the value 421 - So Id like the formula to resolve to =ROUND('BlueCross Rates'!U421,3)
The Vlookup returns the value 421 - So Id like the formula to resolve to
When I click evaluate, the last formula syntax before it fails to #Value is
Note the double quotation marks after the first bracket.
Any help would be much appreciated
Best
A
Id be grateful if you can help. Im getting a value error on this formula and I cant work out why this is the case
The Vlookup returns the value 421 - So Id like the formula to resolve to =ROUND('BlueCross Rates'!U421,3)
Code:
=ROUND("'BlueCross Rates'!U" & VLOOKUP(J3,Workings!J14:K37,2,FALSE),3)
The Vlookup returns the value 421 - So Id like the formula to resolve to
Code:
=ROUND('BlueCross Rates'!U421,3)
When I click evaluate, the last formula syntax before it fails to #Value is
Code:
ROUND("'BlueCross Rates'!U421,3)
Note the double quotation marks after the first bracket.
Any help would be much appreciated
Best
A