+ Reply to Thread
Results 1 to 3 of 3

Lookup Problem

  1. #1
    Forum Contributor
    Join Date
    12-06-2015
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    509

    Lookup Problem

    Dear all

    I have a queries in Lookup in two tables

    Table 1 - I got some data but with a missing "Selling" , it is same in Table 2
    Table 2 - it has the selling and the common file with Table I is the Booking and REference

    How I can looking up the "Selling"in Table 2 from Table 1

    Thanks for helping

    Booking No Services Pax Selling
    Table 1 1 Apt - Hotel 2
    1 Hotel-Apt 2
    2 Apt - Hotel 2
    4 Apt - Hotel 2
    5 Hotel-Apt 2
    6 Hotel-Apt 2
    7 Apt - Hotel 2

    Table 2 Reference Services Selling Costs
    1 Apt - Hotel 100
    1 Hotel-Apt 150
    2 Apt - Hotel 100
    4 Apt - Hotel 100
    5 Hotel-Apt 150
    6 Hotel-Apt 150
    7 Apt - Hotel

    Eric , sorry, the attached file function not working
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,911

    Re: Lookup Problem

    F6=
    Please Login or Register  to view this content.
    F15
    Please Login or Register  to view this content.
    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Lookup Problem

    Or maybe this...
    =INDEX($E$15:$E$21,MATCH(C6&D6,INDEX($C$15:$C$21&$D$15:$D$21,0),0))
    copied down
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem using LOOKUP...
    By shyguy14 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2008, 12:48 AM
  2. lookup problem
    By meteor in forum Excel General
    Replies: 3
    Last Post: 01-30-2007, 09:09 PM
  3. VBA Lookup problem...
    By Stuie in forum Excel General
    Replies: 2
    Last Post: 09-18-2006, 04:32 AM
  4. little problem with lookup i think
    By jose001 in forum Excel General
    Replies: 1
    Last Post: 03-27-2006, 06:55 AM
  5. [SOLVED] Lookup problem
    By Faithskeptic in forum Excel General
    Replies: 2
    Last Post: 12-07-2005, 08:10 PM
  6. [SOLVED] LOOKUP problem!!!
    By G in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. LOOKUP problem!!!
    By G in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. LOOKUP problem!!!
    By G in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1