View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Oshtruck user Oshtruck user is offline
external usenet poster
 
Posts: 9
Default Is there a way to find the address of a cell with a certain value?

I have a grid in an spreadsheet that is 8X8 there are 20 different values in
the grid. What I want is to have a function that will search for the cell
address of a given value. THEN, once I find that Address is there a way to
find out what the value is in the cell above,left,right, and below a given
number of cells????