IF/VLOOKUP Query

[SamuelT]

Hi all,

I'm trying to check to two spreadsheets for the presence of similar
project names. I thought I could do this using a combination of IF and
VLOOKUP:

=IF(VLOOKUP(A2,'[Barclays & Woolwich Retail Tracker 3.3.xls]Programme
(High Level)'!$A$190:$D$283,2,FALSE)=A2,"Y","N")

To clarify:

A2 is the project name
$A$190:$D$283,2 is the range to the VLOOKUP, second column.

I keep getting an N/A result on this though. Any suggestion to what I'm
doing wrong?

TIA,

SamuelT

 

[Bob Phillips]

Why not just try

=IF(SUMPRODUCT(--('[Barclays & Woolwich Retail Tracker 3.3.xls]Programme
(High Level)'!$B$190:$B$283)=A2)>0,"Y","N")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[SamuelT]

Thanks Bob.