View Single Post
  #3   Report Post  
Max
 
Posts: n/a
Default

Sorry, correction* for formula in B3 in:
Put in B3: =IF(B2="Yes",INDIRECT(B1&"!"&$A3),"")
Copy across to F3


Formula should read as:
Put in B3: =IF(B$2="Yes",INDIRECT(B$1&"!"&$A3),"")

*cell refs B2 and B1 corrected to enable copy down later
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----