+ Reply to Thread
Results 1 to 4 of 4

Multi VLOOKUP(LEFT That checks 2 lots of data tables

  1. 08-05-2020, 03:11 AM #1
    pmw19800
    pmw19800 is offline
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    Multi VLOOKUP(LEFT That checks 2 lots of data tables

    Hello All

    i need the below to look at 2 separate data tables,

    Tab Sheet 1 - C1 =IFERROR(VLOOKUP(LEFT(A1,7),Packaging!B18:D49,2,0),"Error") <<< I need that formula to look at 2nd table of data on the packaging tab

    So, It checks both tables,

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-05-2020, 03:27 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Multi VLOOKUP(LEFT That checks 2 lots of data tables

    Is this what you want?

    =IFERROR(IFERROR(VLOOKUP(LEFT(A1,7),Packaging!B18:C49,2,0),VLOOKUP(LEFT(A1,7),Packaging!H18:I48,2,0)),"Error")
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-05-2020, 04:56 AM #3
    pmw19800
    pmw19800 is offline
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    Re: Multi VLOOKUP(LEFT That checks 2 lots of data tables

    Perfect and Thank you
    Reply With QuoteRegister To Reply
  4. 08-05-2020, 05:43 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Multi VLOOKUP(LEFT That checks 2 lots of data tables

    Pleasure!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Alternative to lots of multi-criteria SUMPRODUCT formulas
    By bth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2017, 01:44 PM
  2. [SOLVED] Confusing - Vlookup & 3 Checks on data
    By NotExcelent in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 06-20-2017, 03:08 PM
  3. BIG sheet with lots and lots of data to filter...
    By Amatør in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-25-2016, 08:26 AM
  4. grouping data on date from multi tables
    By pjwhitfield in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-22-2015, 12:26 PM
  5. Adding a condition to an array that checks a cell and then checks 5 columns before
    By gtza in forum Excel General
    Replies: 0
    Last Post: 11-21-2014, 05:00 PM
  6. Multi dimensional Pivot table data issues. Possibly controlling generated tables.
    By JT314 in forum Excel General
    Replies: 0
    Last Post: 04-16-2012, 07:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1