View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default If / Match function help

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