Simon Lloyd
05-14-2007, 03:06 AM
Hi all, is it possible to look at two different cells, match them to celss in another sheet and then display the offset?
If A2 contained "ABC 123" and D2 contained "M" then find both of these in the same row on sheet2 (regardless of the letter contained in D1 they always appear in the same row, i.e A65 ="ABC 890" D65 ="M" the match for these will appear together on a row in sheet 2 so they both might appear on say row100, once found on sheet 2 display the offset from the "found" M (0,-5). Formula to go in G2
I have tried Vlookup and match but could not get it to equate to anything sensible.
If A2 contained "ABC 123" and D2 contained "M" then find both of these in the same row on sheet2 (regardless of the letter contained in D1 they always appear in the same row, i.e A65 ="ABC 890" D65 ="M" the match for these will appear together on a row in sheet 2 so they both might appear on say row100, once found on sheet 2 display the offset from the "found" M (0,-5). Formula to go in G2
I have tried Vlookup and match but could not get it to equate to anything sensible.