Results 1 to 5 of 5

Thread: Get Associated Values

  1. #1

    Get Associated Values



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

    Hello Guys

    I am trying to make something similar. But i am not so good with excel.

    I like to make some standard report

    IF i write Name in first field A1, that it go to table in another sheet and collect data from Table and add it to this 3 fields
    Can i make it with Excel formulas or i need to use macros?

    A1
    A2 B2 C2 D2 E2


    It need to be something like this
    IF A1 IS SAME AS ONE OF THE FIELDS IN (TABLE) COLUMN A THAN USE DATA FROM THAT RAW. AND ADD THEM TO FIELD A2 - B2 - C2 - D2 - E2

    TABLE WITH DATA

    Please help.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	test.png 
Views:	13 
Size:	22.2 KB 
ID:	3451  

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,823
    Articles
    0
    Excel Version
    O365
    Google VLOOKUP, it is very straight-forward.

  3. #3
    Thank you, sorry i am not so good with excel.
    And also this parts was not so easy for me.
    It was easy when you know what to try to find :-)

    Thank you one more time

  4. #4
    Can you post small sample workbook? and type manually the desired results...........

    Click "Go Advanced" button and find paperclip image button to attach your file...........


    regards

  5. #5
    I am new on this website and need to have 5+ posts to be able to add any file.

    Does VLOOKUP have limit for table, how big it can be ?

Posting Permissions

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