One guess ..

Put in A20: =IF('A-V Input'!B200,INDIRECT($D$6)-1,"")
where D6 contains the text: AV1

Adapt to suit
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Lee" wrote in message
...
I have a cell (D6) that has text AV1 in it. Is it possible to have cell
A20
check to see if B20 has a number greater than 0 in it, if it does return
AV1-1. If there isn't return a blank or "-".
At the moment A20 has the following formula in it:
=IF('A-V Input'!B200,"AV1-1","")
I need to copy this 20 times and the change "AV1-1" manually using the
above
formula.
There are other parts but I want to try and solve this first

Thanks,