Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-06-2013, 11:45 AM
BobBridges's Avatar
BobBridges BobBridges is offline Two layer of vlookup issue Windows 7 64bit Two layer of vlookup issue 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Vlookup & IF together thelauncher Excel 5 08-25-2013 11:32 PM
Two layer of vlookup issue IF and VLOOKUP SBMC Excel 1 11-07-2012 10:24 AM
Two layer of vlookup issue Vlookup kkerr Excel 6 08-31-2012 01:23 AM
Two layer of vlookup issue Vlookup ibrahimaa Excel 5 03-04-2012 11:24 AM
Help with VLOOKUP sakhtar Excel 2 07-24-2010 07:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft