Results 1 to 3 of 3

Find a Formula to retrieve big data to add in a different column

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2016
    Location
    usa,CA
    MS-Off Ver
    2010
    Posts
    20

    Find a Formula to retrieve big data to add in a different column

    Hi Guys,

    I would really appreciate if you could make my life easier for this project.
    I want to find the original dates based on the location (Column A) and the amount (Column H) that match the data in the 2nd tab. Please see attached file .

    For example, I have to filter greater than 3k and then manually type the location # to find the data (2nd tab) such as posted date ( Column L) that belongs to (Column B, 1st tab), description (Column H) belongs to Column F, 1st tab) ect... same for reference, Doc# all the blank item in tab 1.

    Thank you so much guys.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to find and retrieve value from elsewhere in sheet
    By tony7262 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-24-2017, 10:59 AM
  2. Replies: 9
    Last Post: 06-20-2016, 07:39 AM
  3. [SOLVED] Home accounts formula help... Retrieve & add data ($) from one column, if category code is
    By ChrisWhite1980 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-26-2014, 02:16 AM
  4. [SOLVED] How to Find a Matching Pattern and Retrieve Data from the Adjacent Column
    By Saarang84 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-10-2014, 09:58 PM
  5. Macro to find cell value in column and retrieve duplicates
    By wwballar42 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2014, 06:45 PM
  6. Coding to Find Cell and Retrieve Row and Column Numbers
    By chaplaindoug in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2013, 01:18 PM
  7. Replies: 1
    Last Post: 01-18-2006, 06:30 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