Results 1 to 3 of 3

Thread: Looking for exact match and return value

  1. #1

    Looking for exact match and return value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have 3 files excel files, File 1 and File 2 fixed contains fixed data in column A with different values in column H

    My third file (dashboard) contains the fixed data found in column A of 2 files, and column B, C, D should return the value located column H.

    Note that the data in column A can be moved to different cells so it should search for the exact match regardless of cell.
    Attached Files Attached Files

  2. #2
    any luck?

  3. #3
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    What you've attached and what you describe do not match.
    Column H is the same in both file 1 and 2.

    What's with the Dashboard.xlsx using columns B, C and D? Are the two H's supposed to be added together or something?
    You have nothing that would indicate the desired results.

    Do you think maybe the lack of responses may have something to do with the presentation of the problem ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •