Home

Horrendously Stuck (VLOOKUP)

morganmarcynuik
Occasional Visitor

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 the following formula:

 

=IFERROR(LOOKUP(C6,Rates!$B$2:$B$10,Rates!$C$2:$C$10),"$0.00")

 

Now it returns a couple of the correct values, doesn't return anything at all or returns a random value from the Rates sheet. I'm beyond frustrated and cannot, for the life of me, figure out what's wrong. I've attached my file in hopes that someone can tell me what I'm doing wrong. 

 

What I'm trying to achieve: 

Be able to enter the "Labour Code" and have the corresponding hourly rate returned into the "Rate" cell via referencing a separate sheet. I know there's another way I could do this keeping it all on one sheet but at this point, it's determination and pride. 

1 Reply

@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)

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies