+ Reply to Thread
Results 1 to 6 of 6

Filling a cell in sheet1 by searching Database

  1. #1
    Registered User
    Join Date
    09-14-2014
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2013
    Posts
    4

    Filling a cell in sheet1 by searching Database

    Hello,

    I am looking for a way as when values in C12, C13 and F13 are entered, excel searches in the database sheet for the same value and reverts back with the corresponding row value and fill up A28, F28 and A34. Images are attached for reference.

    Can anyone please help me.

    Thank you

    Amaan

    Attachment 345295Attachment 345296

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Filling a cell in sheet1 by searching Database

    When you post a spreadsheet, I will look at this for you.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Filling a cell in sheet1 by searching Database

    duplicate to http://www.excelforum.com/excel-gene...in-sheet1.html
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Registered User
    Join Date
    09-14-2014
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2013
    Posts
    4

    Re: Filling a cell in sheet1 by searching Database

    hi mehmetcik,

    Please see attachment

    Sorry HaHoBe! honest mistake.

    Thanks
    Amaan
    Attached Files Attached Files
    Last edited by amaanak; 09-14-2014 at 12:53 PM.

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Filling a cell in sheet1 by searching Database

    This is simple.

    Use a match function to find your data in your database
    Then an offset to get the details.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-14-2014
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2013
    Posts
    4

    Cool Re: Filling a cell in sheet1 by searching Database

    Thank you so much mehmetcik! This is exactly what I wanted.
    Best!
    Amaan

+ 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. Replies: 2
    Last Post: 09-14-2014, 11:21 PM
  2. [SOLVED] Proper Syntax for filling out a template on Sheet2 based upon a row number from Sheet1
    By bmiller29 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2013, 09:50 AM
  3. Replies: 2
    Last Post: 10-12-2012, 11:18 AM
  4. Replies: 1
    Last Post: 09-30-2012, 07:35 PM
  5. Searching Sheet2 to find a match on Sheet1
    By ca1358 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2011, 02:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1