Well, you have a syntax error *plus* you're referencing another sheet.

The correct syntax would be:

=VLOOKUP($B70,Rec!$N$10:$Q$89,4,FALSE)="A"

However, even though you now have a syntax that will work Excel will
complain about referencing another sheet. You can get around that by giving
your lookup table a defined name.

InsertNameDefine
Name: LookupTable
Refers to: =Rec!$N$10:$Q$89
OK

Then use this as the CF formula:

=VLOOKUP($B70,LookupTable,4,FALSE)="A"

--
Biff
Microsoft Excel MVP


"Romileyrunner1" wrote in message
...
Hi guys,
want to run something like this for a conditional format:


=IF(vlookup($B70,Rec!$N$10:$Q$89,4,false)="A")

Obviously it`s vlooking up the value of "A" up another worksheet.
This comes up with an error: highlighting the "A" part.
Is there a syntax error (probably).
Or is there a problem in running a condition from another worksheet?

Thanks.
RR1