View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mpaino mpaino is offline
external usenet poster
 
Posts: 4
Default 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