Forum Discussion
Horrendously Stuck (VLOOKUP)
I've got a spreadsheet which I need hourly rates to be looked up and returned into a cell but read as "$0.00" if nothing has been entered in the Lookup Value cell. It was working fine yesterday with ...
morganmarcynuik , you need to sort you rates table by Code in ascending order to receive correct result. Better
=IFERROR(INDEX(Rates!$C$2:$C$10,MATCH($C6,Rates!$B$2:$B$10,0)),0)