Hi Richard,

Am Fri, 16 Nov 2012 16:21:42 +0000 schrieb Richard Doyle:

1
2
3
4
5

I then want to look to see if "1" is in column A of worksheet"Main", if
it is then display "MAIN" if it is not then check column A of
worksheet"Lower", if it is there display "LOWER" if it is nowhere then
display "NONE" I had the following formula which works fine except for
showing N/A instead of "NONE"

you don't have to use VLOOKUP.
Try:
=IF(COUNTIF(Main!$A$1:$A$5,A1)0,"MAIN",IF(COUNTIF (Lower!$A$1:$A$5,A1)0,"LOWER","NONE"))



Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2