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!
|