No problem...glad it helped

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Naba via OfficeKB.com" <u23570@uwe wrote in message
news:62e1076649659@uwe...
Nick Hodge wrote:
Naba

The theory still holds. (Using your example), in Sheet1 E1 enter

=VLOOKUP(A1,Sheet2!$A$1:$A$10000,1,FALSE)

This presumes your sheet2 is actually called Sheet2

The repeat on Sheet2 replacing the Sheet2 reference with Sheet1 in the
formula

If this returns all #N/As then almost certainly other ways would do the
same
as the data does not 'match'. This can be caused by invisible characters
in
the data or one set of data being 'text', while the others are 'numbers',
although they may look the same.

If you still have problems get back

Nick

Thanks Very much nick, you genus.

Thanks, Nick mate.....

--
Message posted via http://www.officekb.com