Results 1 to 4 of 4

Formula needed for shifting values between columns. How can I achieve this?

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2019
    Location
    Auckland
    MS-Off Ver
    2019
    Posts
    7

    Formula needed for shifting values between columns. How can I achieve this?

    Hello,

    Below I have provided a sample of my data from a much larger dataset. I would like to put the values that are in the green box (under headings X and Y) in the cells of the orange box based on the values in the FID columns. In the orange box I have provided some results that I have manually inserted myself (refer to the green box as to where I derived my results). I hope you can interpret what I am trying to achieve. The issue is that the values of 'FID' under column P have duplicates, whereas the FID under column 'B' does not. Thank you!

    Update: I need to use the VLOOKUP function, but I have no idea how to use this function. Can anybody help with this? Thank you.
    Attached Files Attached Files
    Last edited by sonnyjim1889; 11-05-2019 at 12:57 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA code to remove duplicates without shifting cells
    By belpal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2018, 08:59 PM
  2. Replies: 5
    Last Post: 07-31-2018, 01:43 PM
  3. Shifting cell values based on date
    By GoesATG in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2016, 12:53 AM
  4. [SOLVED] Shifting data based on values
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-03-2014, 06:24 PM
  5. [SOLVED] Find Duplicates and add columns while shifting the cells up
    By jed38 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2013, 09:07 AM
  6. Replies: 1
    Last Post: 02-13-2012, 08:08 PM
  7. matching values in columns that contain duplicates
    By jellybean in forum Excel General
    Replies: 8
    Last Post: 08-14-2006, 09:20 PM

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