• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula Help

jrl1208

Member
Hi

I used a vlookup and match formula in my excel spreadsheet but for some reason it's not working properly.
Can someone please check my formula and advise what is wrong.

Please refer to my excel file. My formula is in the Rates column (AH4) It's not picking up the correct rate base on the status. When I change the status in cell B11 the rates will change but it's not picking up the right rate base on the status.
 

Attachments

  • Dummy Wage.xlsx.xls
    110 KB · Views: 5
Hi,

I have noticed that the value by using which you are peforming a search is different in the lookup sheet and the data sheet i.e. the value Parttime has been written as Parttime14 in the lookup sheet, where as in the data sheet you are searching the value based on Parttime.. when I updated the value as Parttime14 the values are correctly fetched.. see is this helps..

Thanks,
Ram
 
Hi
I've made changes and it still doesn't work. When I change the status in cell B11 the rates is suppose to change but it's not picking up the correct rate.
 

Attachments

  • Dummy Wage.xlsx.xls
    126 KB · Views: 4
Hi @jrl1208 (and all of the participants in post)

You must fix your VLOOKUP from APPROXIMATE search to EXACT search, adding a 0 (or FALSE) in last parameter:

=VLOOKUP(AG4,'Weekly Tax Table (2)'!$F$12:$N$41,MATCH(Tom!F4,'Weekly Tax Table (2)'!$F$12:$N$12,0),0)

Blessings!
 
Back
Top