Vlook Up Help

I have two work sheets. I'd like to know if VLOOKUP would be the right approach to combine the two worksheets into a resulting worksheet. In the attached spreadsheet. I have data in worksheet 10.39 and data in 11.12 that I'm trying to combine/link to create the resulting worksheet named RESULT. I've highlighted the data in teh worksheets to visually show what I'm lokng for. Could someone get me started with a Vlookup statement that will work? Thanks

Originally Posted by nander

I have two work sheets. I'd like to know if VLOOKUP would be the right approach to combine the two worksheets into a resulting worksheet. In the attached spreadsheet. I have data in worksheet 10.39 and data in 11.12 that I'm trying to combine/link to create the resulting worksheet named RESULT. I've highlighted the data in teh worksheets to visually show what I'm lokng for. Could someone get me started with a Vlookup statement that will work? Thanks

you need to enter CUST # in first column in both sheets then enter the same CUST # maually in RESULT sheet in first column. columns B to T in RESULT sheet contain VLOOKUP fomulas to return the result.

here is implementation.