+ Reply to Thread
Results 1 to 2 of 2

Vlookup and Choose to from two or more tables

  1. 12-11-2019, 05:02 PM #1
    Hoppy1958
    Hoppy1958 is offline
    Registered User
    Join Date
    07-19-2018
    Location
    Port Macquarie, Australia
    MS-Off Ver
    2016
    Posts
    8

    Vlookup and Choose to from two or more tables

    Hi team,

    I have a workbook used to track costings and expenditure.
    The information can be input from a pseudo form I created or on the data worksheet itself.
    I have the data matching in the form and the datasheet, however, I'm having an issue with being able to choose the some data from multiple data tables.
    We have a table of projects and separate tables for cost codes associated with those projects.
    In the attached, I'm trying to have the formula find the relevant description in column D of the datasheet in relation to the code in column C.
    The code in column C is obtained from a dependent drop down from Column B. This was achieved through data validation.
    I would be grateful for any help available as I've tried a couple of different vlookup, indirect and choose methods to no avail.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-14-2019, 12:51 PM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,557

    Re: Vlookup and Choose to from two or more tables

    In the long run I think that you'll be better off combining your data tables.
    That said here is a proposal that works for what you have now.
    The sheet names " Code BR2" and "Code BR3" to "CodeBR.2" and "CodeBR.3" (note that there are no spaces)
    The formula used in column D of the Data sheet is: =IFERROR(VLOOKUP(C2,INDIRECT("Code"&B2&"!$A$2:B491"),2,FALSE),"")
    The formula now picks up the descriptions from both sheets (see D455:D456)
    Unfortunately I am unable to upload my copy of the modified workbook as some of the sheets in the workbook attached to post #1 are locked. If you would like to see what I have done please either provide the password, or upload another unprotected workbook.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    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. [SOLVED] Vlookup two tables to choose from 3rd table
    By sp1974 in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 05-30-2017, 09:04 AM
  2. [SOLVED] Choose from tables
    By Andrew.Trevayne in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2017, 10:35 AM
  3. [SOLVED] Vlookup & Choose
    By timbo1957 in forum Excel General
    Replies: 8
    Last Post: 03-22-2012, 10:21 AM
  4. Choose between numbers in different tables
    By johrm50 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2011, 05:49 PM
  5. Excel 2007 : When should I choose IF, AND, VLOOKUP?
    By Garethrowe in forum Excel General
    Replies: 1
    Last Post: 02-01-2011, 08:11 AM
  6. [SOLVED] Vlookup or choose or?
    By Dean in forum Excel General
    Replies: 1
    Last Post: 01-12-2006, 02:25 PM
  7. lookup and choose wih multiple tables of unequal column lengths
    By Lew in forum Excel General
    Replies: 8
    Last Post: 01-02-2006, 07:40 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