Thread: [Solved] Two layer of vlookup issue
View Single Post
 
Old 08-06-2013, 11:45 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

The only way I know to do that, jolinchew, is to put the two values into one cell. Let's call the two workbooks L (for "lookup") and T (for "target"). In T you have the document and line values in a helping column to the right, say cols I and J, an in col B you have the lookup value, the value to be found. In col A you put =I2&"."&J2; this creates in each row the document and line numbers with a period between them, eg "1000020.05".

In L you have the same document and line numbers somewhere off at the right, but your search function says =VLOOKUP(X2&"."&Y2,[etc]), looking in column A of the target worksheet.

If that doesn't make sense to you, we need to be more explicit about what your sheets look like, perhaps post a sample.

Last edited by BobBridges; 08-06-2013 at 11:53 AM. Reason: Posted too soon!
Reply With Quote