+ Reply to Thread
Results 1 to 5 of 5

code to find specific data based on 2 cell entries

  1. 08-04-2021, 04:55 PM #1
    scouse13
    scouse13 is offline
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    code to find specific data based on 2 cell entries

    hi all i need some code to find data on a sheet based on 2 cell entries on another sheet, any ideas much appreciated

    scouse13
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-04-2021, 05:35 PM #2
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: code to find specific data based on 2 cell entries

    looks familiar
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
    Reply With QuoteRegister To Reply
  3. 08-04-2021, 11:15 PM #3
    alansidman
    alansidman is online now
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: code to find specific data based on 2 cell entries

    Try this:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  4. 08-05-2021, 03:09 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: code to find specific data based on 2 cell entries

    Place this code in Sheet1 module

    Code runs after Dip value is entered...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  5. 08-05-2021, 03:48 AM #5
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: code to find specific data based on 2 cell entries

    Please try formula at E5

    =VLOOKUP(D4,CHOOSE(C4,Sheet2!D4,Sheet2!G4,Sheet2!J4):Sheet2!K53,2)

    or 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    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] code find last cell in a specific column in specific worksheet and paste value
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2017, 10:38 AM
  2. How to get counts specific to data based on other entries in rows.
    By John M. in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 12-17-2015, 02:34 PM
  3. [SOLVED] How to get counts specific to data based on other entries in rows.
    By John M. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-17-2015, 03:21 AM
  4. Formulas or code to find multiple entries and change corresponding cell values
    By prazyna in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2015, 04:59 PM
  5. [SOLVED] Need code to pull data based on specific cell selection for comparison
    By aliciaward1001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2015, 06:08 PM
  6. VBA code to find the row number based on data via input box and the highlight a cell
    By Aditya Sabat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2014, 05:47 PM
  7. [SOLVED] Formula to find duplicate entries based on certain specific conditions
    By zicitron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2013, 08:22 AM

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