Getting cell address if a specific value in a cell is found

[lukeshuttlewood]

Hi,

IF a CELL in a COLUMN contains the required NUMBER 'XXXXX' THEN return the ADDRESS of the cell one column to the left.

So its something like....

=IF(L:L = 12345, ADDRESS(OFFSET(0,0,-1))

Im not that good yet!!!

Thanks
luke

 

[Bozacke]

Can you not use a Vlookup

=VLOOKUP(12345,L:M,2,FALSE)

 

[Aladin Akyurek]

Re: Getting cell address if a specific value in a cell is fo

Hi,

IF a CELL in a COLUMN contains the required NUMBER 'XXXXX' THEN return the ADDRESS of the cell one column to the left.

So its something like....

=IF(L:L = 12345, ADDRESS(OFFSET(0,0,-1))

Im not that good yet!!!

Thanks
luke

=ADDRESS(MATCH(12345,L:L,0),COLUMN(L:L)-1)