vlookup across two workbooks

**anelson02** · 09-20-2010, 05:43 PM

I have two workbooks. 2009 and 2010. I have a formula that is not working correctly and I can not figure this out. Look in workbook 2010, column AF for the formula.

What I need is to lookup in 2010, sheet Working B7KD, column O, and match that number to workbook 2009, sheet SAP VSOE, column O. If there is a match then copy Column AF (comments) in 2009 to column AF (explanation) in 2010.

See attached sheets

**TMS** · 09-20-2010, 06:51 PM

Please Login or Register  to view this content.

Regards

**anelson02** · 09-21-2010, 09:57 AM

I use the code but the result come back as all zeros in the column.

**TMS** · 09-21-2010, 11:19 AM

What can I say? I used the workbooks you provided. Are they different to the ones you are using?

However, it looks as though I picked up a formula part way down the sheet. Sorry.

Cell AF2:

Please Login or Register  to view this content.

That will replace the zeroes by blanks because that's what's in the source book/sheet.

I have attached the workbooks you uploaded so you can see it working.

Regards