View Single Post
  #5   Report Post  
Daminc
 
Posts: n/a
Default Showing the contents of a cell based on another cell


This: =INDIRECT("A"&(MATCH(B10,B2:B5,1)+1)) worked great

I'll have to look at the INDIRECT function more closely I think :)


--
Daminc
------------------------------------------------------------------------
Daminc's Profile: http://www.excelforum.com/member.php...o&userid=27074
View this thread: http://www.excelforum.com/showthread...hreadid=483454