Find column and row labels of a table based on a value in the table

ajith

Board Regular
Joined
Nov 21, 2012
Messages
215
Office Version
  1. 2016
Platform
  1. Windows
Hello,
If i am having a table as follows, using excel formulas is there any way to find out the labels of the row and column of a selected value. For eg., if I select 21, the answer should come as 13-05-2013 (dd-mm-yyyy). or if I select 28, 15-06-2013.
ABCDEFG
1MONTH/DATE111213141516
2Apr-13 (mmm-yy)1718HHH19
3May-13H2021222324
4Jun-1325H262728H
5July-13293031323334

<tbody>
</tbody>
Please help.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
This Can't Be Done With A Formula Because You Can't Use The Selection In A Formula,So You'll Have To Have A Macro!
ZAX
 
Upvote 0
If selected means typed (in B7 for example) then may be this:
Excel Workbook
ABCDEFGH
1Date (mmm-yy)Min111213141516
2Apr-13171718HHH19
3May-1320H2021222324
4Jun-132525H262728H
5Jul-1329293031323334
6
7Selected Day28
8Match VerticalJun-13
9Match Horisontal15
10Result15-Jun-13
11Single Formula15-Jun-13
Sheet
 
Upvote 0
Hi Ajith,
Glad it helped!
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,337
Members
448,568
Latest member
Honeymonster123

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
Back
Top