+ Reply to Thread
Results 1 to 2 of 2

Pull Values from 'data sheet' into 'check sheet' based on serial no

  1. #1
    Registered User
    Join Date
    01-16-2024
    Location
    London
    MS-Off Ver
    M365 Ver 2302
    Posts
    6

    Red face Pull Values from 'data sheet' into 'check sheet' based on serial no

    Hi All

    Is anyone able to help with the formulae which pulls the margin result based off the serial no from 'data sheet' and auto inputs this for the respective serial no in 'check sheet' (Margin result box)

    see attached spreadsheet

    many thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Pull Values from 'data sheet' into 'check sheet' based on serial no

    =INDEX(Data!$B$4:$B$14,MATCH(Check!B2,Data!$A$4:$A$14,0))
    copied into the various cells needed
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. pull values from sheet to next sheet based on matching column and empty cells
    By abdo meghari in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2022, 02:27 AM
  2. Pull Data from sheet 1 to sheet 2 based on content in sheet 2 using vba
    By shina67 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-22-2022, 03:41 PM
  3. VBA : Pull Data From Multiple Sheet Into 1 Sheet Based On Criteria
    By Jhon Mustofa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2022, 11:58 PM
  4. How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'
    By goonshiredgoons in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-13-2015, 03:41 PM
  5. Formula to pull data from one sheet to a new sheet based on date range
    By lisajolley11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2015, 08:38 PM
  6. Function to check the sheet name exist or not based on sheet values
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-12-2014, 09:37 AM
  7. Replies: 5
    Last Post: 07-23-2013, 01:17 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1