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.
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.