Thread: Look up values in a column and return ALL corresponding row number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ima Nidiot Ima Nidiot is offline
external usenet poster
  
Posts: 2
Default Look up values in a column and return ALL corresponding row number
I'm sure this is an easy one...

I have 2 worksheets (S1 & S2). Column 2 in S2 contains a list of ID's that
I want to search in column 8 of S1 for and return the row number for every
matching cell.

There may be some ID's that have 0 matches, 1 match, 2 matches, ... n matches

Any help would be appreciated.

Reply With QuoteReply With Quote