Thread: Find Cell with Value and get Value of Cell Below it
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default Find Cell with Value and get Value of Cell Below it

Name the cells with data in column E.
I used the name "LookupRange"
Place this formula in cell B15...

=INDEX(LookupRange,MATCH("Tackles",LookupRange,0)+ 1,1)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"CribbsStyle"
wrote in message
I need to find the word "Tackles" in Column E and then have the value
of the cell below it inserted into B15 on another sheet. This seems
like it would be simple...but for some reason cant do it, lol. Any
Help?
Reply With QuoteReply With Quote