BJ

Thanks it is not a length issue though
Thanks
ETC


"bj" wrote:

if you can visulally see what looks like a match
if the data is text
try
=a2=RPT7571!B4
(if B4 is the apparent match)
if the answer is false check
=len(a2)

and
=len(RPT7571!B4)

you may need to put a trim() function in your equation

if the data is numeric try increasing the number of significant figures to
insure that it is not a round off issue in both cells.
also one may truely be text even if it looks numeric

"Sweetetc" wrote:

I am trying to accomplish a vlookup within the IF statement but it won't work


=IF(VLOOKUP(A2,RPT7571!B:I,4,FALSE)="2",VLOOKUP(A2 ,RPT7571!B:I,5,FALSE),"")

I have 2 spreadsheets with info. I am trying to say in a cell in
spreadsheet 1 - look into speadheet RPT7571 and if A2 matches A2 in my
spreadsheet 1 then look over 4 columns and if the 4th column has a value of 2
then return the value in column 5 of the RPT7571 spreadsheet into my
spreadsheet 1 otherqise return nothing.

It does not work
Help

--
Thanks
ETC