# Match Function Not returning the correct row address

#### SanjayGulatiMusafir

##### Board Regular
I have a table that carries multiple entries of same date - Sorted in Ascending Order.

I'm using following formula to get Cell address that contains today's date

Excel Formula:
``=ADDRESS(MATCH(TODAY(),Banks[Dt],1),3,4,1)``

But it returns cell address 2 to 3 cells above the desired cell.
• I have tried using "0" in match function, but that doesn't help.
• Also, occasionally current date goes missing in the table, thus using "1" for approximate match becomes, probably, mandatory.
Can someone help me identify where I'm going wrong and also help improve the formula.

Thanks

#### Attachments

• Screenshot 2021-02-24 at 21.17.14.png
69.5 KB · Views: 8

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### RoryA

##### MrExcel MVP, Moderator
MATCH returns the position within a range, not its row number. The two may happen to be the same if your range starts in row 1, but that won't be the case with a table since the headers are usually in row1.

#### SanjayGulatiMusafir

##### Board Regular
MATCH returns the position within a range, not its row number. The two may happen to be the same if your range starts in row 1, but that won't be the case with a table since the headers are usually in row1.

#### RoryA

##### MrExcel MVP, Moderator
You might also want to replace the 3 in your formula with COLUMN(Banks[Dt]) so it will adjust automatically if you move the table.

#### SanjayGulatiMusafir

##### Board Regular
You might also want to replace the 3 in your formula with COLUMN(Banks[Dt]) so it will adjust automatically if you move the table.
Thanks RoryA

It worked like charm.

Thanks again

Replies
7
Views
333
Replies
2
Views
491
Replies
9
Views
292
Replies
4
Views
165
Replies
3
Views
144

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,151,972
Messages
5,767,393
Members
425,410
Latest member
SmittyT

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

### Which adblocker are you using?

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

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