Hi,,

Try this in Sheet 2 j1 and drag down to the length of column B.

=IF(ISNA(VLOOKUP(C1,Sheet1!B$1:F$6,5,FALSE)),"Not
found",VLOOKUP(C1,Sheet1!B$1:F$6,5,FALSE))

Mike


"jpreman" wrote:

Thanks for reading this post.

In Sheet 1 column B I have a list of numbers(eg. Staff No) and in column F
there are some values (eg. Incentive) against each number. Sheet 2 column C
contains a list of numbers which includes many of the numbers from the
previous sheet (ie. sheet 1 Column B) but not in the same sequence. Column H
has the values.

I want to compare sheet 1 column B with sheet 2 column C and where a match
is found to display the corresponding value from sheet 1 column F in sheet 2
column J.

How can I achieve this?