Hi,

Take a look at the VLOOKUP function in the help system.

Cheers,
Shane Devenshire

"WAM" wrote:

I'm trying to import values in column J of sheet 2 to column k sheet one
oppsite matching values for solumn one sheet one and sheet two

please advise