Thanks that works perfectly.

Can I ask if it is possible to add this formula to a number of cells in one
go that are already populated with the original and incorrect formula, so I
don't have to go back and enter your formula to some 200 cells?

"Max" wrote:

"Scoober" wrote:
.. the formula in A1 is currently =RP1!D5

One usual way: =IF(RP1!D5="","",RP1!D5)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---