Thread: formula the finds value of cell above
View Single Post
  #2   Report Post  
stnkynts stnkynts is offline
Junior Member
  
Posts: 6
Default
=OFFSET(A1,MATCH("CMR107",A2:A700)-1,0,1,1)

This isnt the best way but it worked for me. You have to know what column you are searching in though. When I have more time ill try to get a better formula together.
Reply With QuoteReply With Quote