![]() Select a cell and type AA into it, here I type AA into cell A26. ![]() To lookup a value and return corresponding cell address instead of cell value in Excel, you can use the below formulas.įormula 1 To return the cell absolute referenceįor example, you have a range of data as below screenshot shown, and you want to lookup product AA and return the relative cell absolute reference.ġ. Lookup a value and return cell address with formula But here I will introduce some formulas to lookup a value and return the relative cell address. In general, you will get the cell value when you use formula to look up a value in Excel. ![]() How to lookup a value and return cell address in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |