I have a spreadsheet which references 8 others and has data loaded from
another system.

I am trying to get the final part of the worksheet to check the three fields
(which are IF/VLOOKUPS) are ALL greater than 0%.

If they are then the function is to do one final VLOOKUP to return another %.

I have no problems with using IF or VLOOKUP and I have tried AND which
always produces a TRUE response even if one or two of the cells are empty or
zero. I can not see how LOOKUP would work and I would need more that 7 IF
statements trying that route.

Your help would be appreciated as this will save one person manually
calculating figures for over 1/2 day in HR.

Thanks in advance


--
Len