Results 1 to 4 of 4

Which LOOKUP function to use and Keeping Formula Column Constant when Inserting Columns

Threaded View

wendy823 Which LOOKUP function to use... 02-14-2022, 12:31 PM
FlameRetired Re: *May be duplicate... 02-14-2022, 01:16 PM
wendy823 Re: *May be duplicate... 02-14-2022, 05:10 PM
AliGW Re: Which LOOKUP function to... 02-14-2022, 05:23 PM
  1. #1
    Registered User
    Join Date
    09-01-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    25

    Which LOOKUP function to use and Keeping Formula Column Constant when Inserting Columns

    Have a spreadsheet that another user helped me with a great function. I am wanting to tweak the function, but have not been able to quickly figure it out on my own.

    Attached s'sheet shows 5 columns. The 5th Column (Check) locates a value from Column A from an array Columns D and E and then returns the difference in prices (sums) between Columns B and E. If there is no difference, it returns "Identical". If the string of text in Column A is not found, formula returns NA.

    ****I am wanting to do two things****
    1. Move column F - the "Check" column over to column A.
    2. I want to keep column A constant and have it work when, weekly, I insert two columns directly after column A with new weekly data. I looked in to using the "My Forumla" feature (Forumlas>Define Name), but could not seem to get it to work consistently.

    Thank you so much!
    Attached Files Attached Files
    Last edited by wendy823; 02-14-2022 at 02:20 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Duplicate lookup and sum function
    By Aber05 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2021, 02:39 PM
  2. Modifying an INDEX and MATCH formula to advance if duplicate found
    By kgrlx in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2020, 12:35 AM
  3. [SOLVED] Duplicate Value Lookup Function Problems
    By svatz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2013, 12:55 PM
  4. Advance LookUp....
    By ZarrinPour in forum Excel General
    Replies: 2
    Last Post: 05-31-2010, 01:29 AM
  5. lookup advance to higher value
    By Lparker977 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 03:33 PM
  6. Advance lookup function
    By deluxman in forum Excel - New Users/Basics
    Replies: 15
    Last Post: 12-30-2008, 11:41 AM
  7. Advance LOOKUP !
    By herverob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2008, 09:54 AM

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