Sheet1 column B contains my customer number- I need to locate this customer number in Sheet2 column F. Then copy the value from Sheet2 AE (from the row with the matching customer number) into the matching customer number row in Sheet1 column E. Note that sheet1 column B and Sheet2 column F contain the same customer numbers, but not in the same order and sorting is not an option.
views:
36answers:
1
+1
A:
So, after much trial and error I worked out the perfect solution! Thought I'd share just in case anyone else is trying to do the same.
Cheers!
into column E I entered =INDEX(sheet2!$AE$4:$AE$10000,MATCH(B4,sheet2!$F$4:$F$10000,FALSE)*1)
julzy
2010-01-15 21:18:01