How to use match formula: input data range based on cell value
Requirement:
In regards to the formula =ADDRESS(MATCH(M13,'Sheet1'!K1:K23,0),11)
The user would like the value of K1 in the above formula to equal the cell value of cell G13 in Sheet2. If it helps, the cell value on cell G13 in Sheet2 is $K$6.
Solution:
=ADDRESS(MATCH(M13,INDIRECT("'Sheet1'!"&G13):INDIRECT("'Sheet1'!K23"),0),11)
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to match positive and negative values within subgroups |
| How to compare 2 date ranges when name matches |
| How to use SUMPRODUCT with INDEX MATCH multiple criteria |
| How to check values in a column and if condition matches then populate 3 other columns. |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
