Results 1 to 8 of 8

LOOK UP VALUE in DB and FILL MISSING VALUES in ANOTHER XLS file

Threaded View

  1. 05-05-2020, 05:09 PM #1
    sealpino
    sealpino is offline
    Forum Contributor
    Join Date
    11-10-2012
    Location
    Sweden, Stockholm
    MS-Off Ver
    MS Excel 365
    Posts
    200

    LOOK UP VALUE in DB and FILL MISSING VALUES in ANOTHER XLS file

    HI

    THX FOR LOOKING

    I have a working sheet "STAT TEST" that will have missing data in two columns.
    I have a simple database where values are located, see "DB1".

    I want to look up the values in column 1 for each row in STAT TEST and get missing data in two columns!

    Easy task for someone but hard for me
    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Using isblank to fill in missing values
    By salimnore in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-10-2015, 09:53 PM
  2. How to calculate Average of daily data to fill missing values
    By mahjid in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2013, 05:46 AM
  3. Fill Missing Values
    By ramzan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 01:24 PM
  4. [SOLVED] Fill in missing values of one row with the rows beneath it if the rows beneath match
    By ilikeexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2012, 02:40 PM
  5. [SOLVED] Auto Fill "Missing" based on two dates values
    By Tejas.T in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-31-2012, 04:22 AM
  6. Looking up info from a seperate Excel file to fill multiple cell values
    By JesseM in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-29-2010, 05:28 PM
  7. Using Linear Regression to Fill in Missing Values
    By Matty's Dilemma in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-30-2009, 06:56 PM

Tags for this Thread

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