+ Reply to Thread
Results 1 to 5 of 5

Need Help INDEX Formula or V Lookup Formula Funtion for Data Sheet

  1. #1
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    144

    Need Help INDEX Formula or V Lookup Formula Funtion for Data Sheet

    Dear sir,

    I have data some data Sheet 2 Data record and sheet no 1 Database Combobox up here data is showing size and price ect after that not not display any data in combobox kindly help me, file attached.

    sir iam new about excel working if you dont mind can you apply formula and re send me data sheet iam trying to apply but i dont know thanks

    Data Sheet attached

    Enpac Selling Price List.xlsm

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,992

    Re: Need Help INDEX Formula or V Lookup Formula Funtion for Data Sheet

    There is nothing wrong with your attached file as I hope.

    I have just inserted a helper column in Data record sheet putting some row numbers for better clearance for Index function.

    Check the attached file, Hope this will help you.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  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
    53,047

    Re: Need Help INDEX Formula or V Lookup Formula Funtion for Data Sheet

    shukla.ankur281190 Sorry for off-topic interjection:

    Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!
    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

  4. #4
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Need Help INDEX Formula or V Lookup Formula Funtion for Data Sheet

    I went simple, change dynamic list with easy vlookup
    Attached Files Attached Files

  5. #5
    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
    53,047

    Re: Need Help INDEX Formula or V Lookup Formula Funtion for Data Sheet

    lcartwright please read my post above, and add your formula

+ 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. [SOLVED] Index Match Formula Issue - Lookup Value is a Formula
    By dodgemain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2016, 11:48 AM
  2. [SOLVED] Index Match Formula doesn't recognize output from Right Formula as lookup value.
    By GoGators in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2015, 11:33 AM
  3. Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  4. [SOLVED] Data Validation populated by lookup/ Index:match type formula
    By strud in forum Excel General
    Replies: 4
    Last Post: 09-30-2014, 07:09 AM
  5. Replies: 0
    Last Post: 01-22-2013, 09:40 AM
  6. Index Formula For Data From Another Sheet
    By Kumara_faith in forum Excel General
    Replies: 2
    Last Post: 09-05-2008, 08:51 AM
  7. Lookup funtion referenced from another sheet.
    By zzzaps in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2006, 12:10 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