ExcelBanter - View Single Post

shail

Hi Anthony

I have the email id , you can send the excel file
here. Anyway, RagDyeR has posted VLOOKUP formula for you, if that
works for you it is ok, otherwise you can send me the file.

Thanks,

Shail

Anthony wrote:
Your profile has an email address are you on it now and i'll email excel file
easier than trying to explain without the worksheets

"shail" wrote:

Hi Anthony,

Can you give me an example?

Thanks,

Shail

Anthony wrote:
In simple terms

Column A on worksheet 1 contains 100 rows of 16 digit tag identities

Column A on worksheet 2 contains a list of 21000 rows of 16 digit tag
identites from which the 100 on sheet 1 are drawn. Column B on sheet 2 shows
a secondary unique identity for each tag.

For each tag on sheet 1 need to match and display in column C sheet 1 its
secondary ID listed in column B sheet 2