In this example we will look for a Customer using its ID and return the address of the cell that contains the customer’s city.
Showing posts with label return cell reference. Show all posts
Showing posts with label return cell reference. Show all posts
Saturday, 7 June 2014
Return the Cell Reference instead of the Value from a Lookup
In Excel, Lookup functions such as Vlookup or Index and Match can be used to find a record and return a value. But what if you want to return the cell reference, or address, instead of the value.
In this example we will look for a Customer using its ID and return the address of the cell that contains the customer’s city.
In this example we will look for a Customer using its ID and return the address of the cell that contains the customer’s city.
Subscribe to:
Posts (Atom)