Menu
is there a way to get address_of(vlookup(.....)) ??
where address_of = "A25" (or something in that format) ??
595
The Excel ADDRESS function returns the address for a cell based on a given row and column number. For example, =ADDRESS(1,1) returns $A$1. ADDRESS can return an address in relative, mixed, or absolute format, and can be used to construct a cell reference inside a formula.
XLOOKUP can only return a reference to a single cell, row or column, not a whole table consisting of multiple rows and columns. It's also only available to Excel for Microsoft 365 users.
Besides returning value in an adjacent cell, you can vlookup and return value in the next cell of the adjacent cell in Excel.
=ADDRESS(MATCH(60,A1:A12,0),1)
Missed out the ,0 making it approximate and not an exact match. This is not good for drop downs combo menus; if two things can be the same, then you need an exact match or it picks up the last one.
169
Use MATCH() rather than Lookup. The formula below assumes you've got a lookup table in A1:A12.
It looks for the value "60" and turns the returned row index into a textual range address (e.g. "$A$6").
=ADDRESS(MATCH(60,A1:A12,0),1)
The third parameter in MATCH() makes this an exact match.
39
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
