I'm trying to find a formula to find the exact cell address for a value in a table (or named range).
The formula below does not work as the Match formula will only work for a row or column range. Does anyone know how to fix this? Thanks.
=CELL("address",INDEX("Named Range",MATCH("search value","Named Range",0),1))