+ Reply to Thread
Results 1 to 2 of 2

Transferring Notes through XLOOKUP?

  1. #1
    Registered User
    Join Date
    02-22-2024
    Location
    USA
    MS-Off Ver
    Microsoft 365
    Posts
    1

    Transferring Notes through XLOOKUP?

    Hi all,

    I am working in a model and we are consolidating the data source for the sheet. However, on the original tab, there were many notes entered, explaining where a certain number came from/why it is higher or lower/etc. I cannot copy and paste this list of data+notes into the main model, because it is not a perfect match. Is there a way to "XLOOKUP" the notes? Or some other method of transferring the notes without having to go cell by cell and copy/paste. Attached is much smaller example. There is a list of data with formats and notes, and I would like to take all of the cell content and match it to the matching project names in a separate list. I do not want to use copy and paste, because the list is different and in a different order.
    Attached Files Attached Files
    Last edited by golskyhop9819; 02-22-2024 at 06:58 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: Transferring Notes through XLOOKUP?

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Xlookup Value
    By kirana2014 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-21-2023, 09:50 AM
  2. Xlookup help?
    By KArl419 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-18-2023, 09:22 AM
  3. [SOLVED] How to Use XLOOKUP In VBA
    By PosseJohn in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-30-2022, 01:50 PM
  4. [SOLVED] XLOOKUP gives N/A
    By Hexdax in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-23-2022, 04:06 AM
  5. [SOLVED] Xlookup in PQ
    By Excelski in forum Excel General
    Replies: 7
    Last Post: 09-09-2021, 07:15 AM
  6. Embed image into Lotus Notes with VBA - not using Notes.NotesUIWorkspace
    By pmor1503 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2014, 11:49 PM
  7. end notes, foot notes and an Index Table
    By thadacto in forum Word Formatting & General
    Replies: 1
    Last Post: 12-27-2011, 06:22 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