How to Return Cell Address Instead of Value in Excel (Easy Formula)

When using lookup formulas in Excel (such as VLOOKUP,  XLOOKUP, or INDEX/MATCH), the intent is to find the matching value and get that value (or a corresponding value in the same row/column) as the result. But in some cases, instead of getting the value, you may want the formula to return the cell address of ... Read more

from Online Excel Tips – Blog – Trump Excel https://ift.tt/3n27iCC