Lookup adjacent Cell Value from 1 column in Sheet2 using Cell Value in Sheet 1

GlenMc52

New Member
Joined
Jul 28, 2021
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
I have a spreadsheet for my wife's income to be able to due reporting. I have multiple pages and the last page is the Tax Sheet, it has and range of wages
in Column A and the appropriate Tax instalments in Column B.
In this last page I can use the following formula:
=INDEX(B1:B425,MATCH(N42,A1:A425,0)) - this formula is placed in cell N43
and it will give me an answer in cell N43.
Cell N42 is the wages earned and Cell N43 is the Tax payable.
Now here is my problem:
When I go to my first sheet for Week 1 wages the formula doesn't work.
So Cell N42 has the wages earned and in Cell N43 I have the following formula:
=INDEX(Tax!B1:B425,MATCH(N42,Tax!A1:A425,0))
and this gives an answer of #n/a.
If I replace the N42 in the formula with the actual wage say$1049 it will give me the
correct answer in Cell N43 (Tax instalment).
 

Attachments

  • 2021-07-28-22-57-31.jpg
    2021-07-28-22-57-31.jpg
    229.4 KB · Views: 4

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,176,168
Messages
5,901,734
Members
434,914
Latest member
mabek

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top