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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 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
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies