vlookup help - returning matching ones with rest of column info

[gamurphy64]

Tab1 has information below with full description. (68k lines)

ID Harrison Manufacture Material Description Size Product Type Install Type Specification
001CA0007F Harrison Chicago Area Carbon Steel Sch 40 SA-53B CS CW PIPE T&C 1/2 Pipe Threaded Sch 40
001CA0009F Harrison Chicago Area Carbon Steel Sch 40 SA-53B CS CW PIPE T&C 3/4 Pipe Threaded Sch 40
001CA0011F Harrison Chicago Area Carbon Steel Sch 40 SA-53B CS CW PIPE T&C 1 Pipe Threaded Sch 40
001CA0013F Harrison Chicago Area Carbon Steel Sch 40 SA-53B CS CW PIPE T&C 1-1/4 Pipe Threaded Sch 40


Tab2 has only ID info (28k lines)

ID
001CA0013F
001CA0015F
001CA0017F
001CA0019F
001CA0021F

I want to do a vlookup from range on Tab1 and Tab2 and return the ID matched along with the description informaiton found on Tab1? What is the formula. Need lots of help here!

Thanks,
Greg

[kbkumar]

Please upload a sample workbook as its difficult to make out columns from your textual data...

[gamurphy64]

Here is a sampling of my data. Tab1 is called MapProd and Tab2 is called Labor. I want to match data from column 1 MapProd with Labor Column 1 and return on another tab with full description data on MapProd. Let me know if you need more clairification.

Thanks,
Greg

[FDibbins]

you can use this in E2, copied down and across...
=INDEX(MapProd!$A$1:$N$5000,MATCH(Labor!$A2,MapProd!$A$1:$A$5000,0),MATCH(Labor!E$1,MapProd!$A$1:$N$1,0))

Note: you have a training space Labor G1, the above will show error until you remove that