View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bob
 
Posts: n/a
Default Two worksheets, one array

Sheet1 Column A2:A25 has a list of numbers. I want to display in Sheet2 cell
A2 the number 725595 if it appears in Sheet1 Column A2:A25.

I also want to display in Sheet2 cell B2 the value that is in Sheet 1 Column
B in the same row as 725595.

Can anyone help?

Thanks,
Bob