Find a value in a table and return the cell reference
Hi All,
is it possible to create a function that will look for a text/value in a
table and return the cell reference? I only have dierent values in the table,
no value repeats.
For Example:
table A1:C3
aaa bbb ccc
abb abc acb
baa bba bbc
in another cell (J2) I have the value "abc" and I want a formula to return
the cell reference in the spreadsheet nest to it. I don't want the "abc" in
the formula because I want to find different values.
function(J2) returns the cell reference in the spreadsheet, B2.
Thanks a lot for the help
|