Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

List comparisons

Status
Not open for further replies.

chkote

Technical User
Nov 21, 2000
42
AU
I have 2 Lists/Arrays
List1 : 1,2,2,4,1
List2 : 0,0,0,4,0

What I'm trying to do is compare List2 with List1 and find the first value in List2 that matches a value in List1 in the corresponding position. In this case "4".
Thanks

 
P.S. Forgot to mention...I want to do this in Excel
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top