Sean,
When i put the formula =INDEX(Sheet2!B:B,MATCH(A3,Sheet2!A:A)) in sheet 1
cell E2 it worked good. The only problem is that sheet 2 wont/dosent have all
id# like sheet 1 has and when i put the formula, even though there there was
no id#2 on sheet 2 it copied the value from the above cell instead of leaving
cell blank

"Herbert Seidenberg" wrote:

Used Pivot Table, VBA and
Excel 2003 Lists. No formulas used.
Data can be located anywhere,
can have odd rows and columns,
be in random order and incomplete.
Dynamic data ranges provided for easy editing.
http://www.freefilehosting.net/download/3d94b