Thursday, 22 September 2016

How to Get the Cell Address of a Matching Column and Row in Excel

Excel Function to Get the Address of Matching Column and Row in Excel
Suppose we have the Field or Column names as follows in the source data tab as follows :

Now in our calculation sheet, if you want to capture the Address/Column Index Number/Name details of the lookup Fields/Column Names, we can do as follows :

Lets say the source data tab is "Data", and our lookup Fileds/Columns names in Column A which exists in Row 1 in source data tab, then now the formulas to get each item from source is as follows:
Field Address in Source:

Field Row Number:

Field Column Number:

Field Column Index Name:


No comments:

Post a Comment

Hi User, Thank You for visiting My Blog. Please post your open Feedback only related to this Blog Posts. Please note that I cannot respond to the Anonymous Comments.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts