IF/VLOOKUP Query
 

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


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=568239

IF/VLOOKUP Query
 

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" wrote in
message ...

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


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=568239

IF/VLOOKUP Query
 

Thanks Bob.


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=568239