manipulating formula values

[Ramy]

Hi,
i'm trying to use the values returned by a formula to create anothe
formula. In other words, I have 2 columns. The first being a =vlookup(
formula, the second being a number. I would like to compare the valu
returned by vlookup and the number in the second column. how do i d
this?
ram

 

[JulieD]

Hi Ramy

in the third column type
=A1=B1
where A1 is the cell containing the result of the VLOOKUP and B1 is the cell
containing your number. You'll get a TRUE if they match and a FALSE if they
don't.

Cheers
JulieD

 

[Ramy]

doesn't seem to be working for me. I'm doing =A1=B1 where A1 and B1 hav
the same value as far as I can see. I'm getting FALSE

 

[Ramy]

never mind. i just needed to =Trim() the comparative column. Thanks fo
your help

 

[JulieD]

Hi Ramy

glad it's sorted .. thanks for the feedback

Cheers
JulieD