Results 1 to 23 of 23

Comparing values betwen sheets and returning values

Threaded View

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Darwin, Australia
    MS-Off Ver
    Office 365
    Posts
    34

    Comparing values betwen sheets and returning values

    Hi,
    I am getting really confused using the match address and indirect statements in a formulae.
    I have attached an excel example of what I am trying to achieve and I'm hoping someone can assist.

    I have two worksheets EUC and DV:
    Worksheet EUC contains a column of asset numbers (column 1)
    Worksheets DV contains a range of assets held by a person. The person's name is column A and the asset numbers are in columns B, C, D, E, F.

    What I am trying to do is beside each of the Asset Numbers in EUC place the name that corresponds to that number from sheet DV Column 1,
    In the DV asset register there is a total of 4 assets that a person can hold.
    If they don't hold the asset then the cell is blank otherwise it has a number in it.

    I have tried using the MATCH function but am getting an error.
    The Row 1 show the headers of what I am trying to get.
    I want to use this as a learning example.

    If anyone can help I would greatly appreciate this as currently I have to do each asset number manually using copy and find. There is a lot of assets.

    Cheers Tony
    Attached Files Attached Files
    Last edited by tonez90; 02-15-2024 at 09:44 PM. Reason: closing as solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Comparing 2 values and returning 3 possible answers
    By Bash66 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2019, 12:43 AM
  2. Replies: 1
    Last Post: 10-01-2013, 02:41 AM
  3. Replies: 6
    Last Post: 02-22-2012, 11:26 AM
  4. Comparing columns and returning several values in to one row.
    By Chemgeorge in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-20-2010, 08:40 PM
  5. Comparing lists and returning corresponding values
    By ronoc88 in forum Excel General
    Replies: 1
    Last Post: 07-16-2010, 12:20 PM
  6. Returning different values when comparing 2 cells
    By Carl1966 in forum Excel General
    Replies: 1
    Last Post: 09-09-2008, 08:15 AM
  7. [SOLVED] Comparing databases and returning values
    By Jonas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-06-2006, 12:45 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