Thank you Debra and Ken ~

Once I got the format right, both formats seem to work. I think the IF
statement is the better option. On initial run, worked great.

New SLIGHT problem. :( My reference table needs to be updatable. I
updated it and a step was removed from the reference list. It didn't change
to a 0 on the other sheet.

=IF(VLOOKUP(A784,CapModXtab!$A:$I,3,TRUE)=1,1,0)

That's the formula. I had the reference table as a query pointing back to
the db so I could update it in excel. Didn't update when step changed.
Removed that and copied the reference table in, didn't change either.

It's probably basic, but what am I missing?!?!

Thanks much!!!
Barbara

"Ken Wright" wrote:

=IF(your_formula=8,1,"")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03