Alan/Mike

Thank you for your help but I had tried both of your suggestions and it
still picks up the VLOOKUP even if one or two cells are blank or Zero.

Could it be the Excel settings?
--
Len


"Alan Moseley" wrote:

Surely you just need:-
=IF(AND(A10,B10,C10),VLOOKUP(etc),"")

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"Len" wrote:

Mike H

Thank you for your reply. However it returns the VLOOKUP when one of the
cells is zero.

Re-reading my original note I may have caused confusion so I will try again:

Each of the cells must be greater than 0% before I pull through the VLOOKUP.

A1 B1 C1
0% 5% 7% False no VLOOKUP
3% 5% 7% True perform VLOOKUP

Hope this helps you?

Thanks in advance


--
Len


"Mike H" wrote:

Len,

use MIN

=IF(MIN(A1:A3)0,"do this lookup","Do something else")

Mike

"Len" wrote:

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