+ Reply to Thread
Results 1 to 4 of 4

Can we use VLookup to fill in fields from Scattered Data ?

  1. #1
    Registered User
    Join Date
    05-10-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    Question Can we use VLookup to fill in fields from Scattered Data ?

    Hi,

    I wanted to know that is it possible to use VLookup to fill in data in certain row by matching it from different rows rather than just from a single row.

    In the attached image, I want to fill in the cells next to "Yellow" i.e. (H4) & "Pink" i.e. (H7) by using the same formula I used to in H2 cell which is "=VLOOKUP(G2:G7,A2:E12,2,0)
    ". NOTE - That I have selected the table array from "A2:E12" which covers the values of D11, E11 & D12, E12 in which the "Yellow" and "Pink" information is given. I do realise that the source has become different now, but is there a way in which I can fill in H4 & H7 through ANY FORMULA (if Vlookup can't be used) where I don't have to restructure the data in the sheet.

    123.JPG

    P.S. - The data I shared in the image is very small, but if I figure it out then I can apply to large data which is similar to this problem.

    Thank You in advance.

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Can we use VLookup to fill in fields from Scattered Data ?

    Does this work?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-10-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    Re: Can we use VLookup to fill in fields from Scattered Data ?

    Hi,

    I have inserted that value in cell "H4" & "H6" but It's filling in incorrect value of "2500" in both of them.

  4. #4
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Can we use VLookup to fill in fields from Scattered Data ?

    You have to put the formula in H2 and drag down. The formula is looking at G2 to start, and will adjust based on the row as you drag down.
    If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.

    If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.

+ 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. Bring scattered data to correct columns
    By vadaniels in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-22-2020, 10:32 PM
  2. Replies: 1
    Last Post: 08-21-2018, 10:46 AM
  3. Summarizing Scattered Data
    By onlyFMF in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2017, 07:17 AM
  4. [SOLVED] Graph from scattered data
    By gmasterrr in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-30-2014, 03:51 AM
  5. Bilinear interpolation of scattered data points
    By Sebi in forum Excel General
    Replies: 15
    Last Post: 09-19-2012, 01:05 AM
  6. Replies: 1
    Last Post: 05-26-2012, 05:37 PM
  7. time scale-x with scattered data-y
    By searching for answer in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-20-2005, 05:05 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