Hi,

Im glad it solved you problem. How does it work?

VLOOKUP(C1,Sheet1!B$1:F$6,5,FALSE)
The looks for the value held in c1 in b1 - b6 of sheet 1. If it finds it
then the corresponding value colum 5 of the array is returned (col F). False
tells it to return exact matches only.

Mike


"jpreman" wrote:

Hi Mike,

That's really fast.

Thanks a lot

Mike, can you kindly explain your formula in brief.


"Mike H" wrote:

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?