+ Reply to Thread
Results 1 to 9 of 9

help VLOOKUP() OR SOME FORMULAS

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    Lightbulb help VLOOKUP() OR SOME FORMULAS

    Hello dear users , i have a problem because i need a formula for my work project .

    i have a table like:
    Cap1.PNG

    and in another sheet i need to get values on yellow cells like
    CAP2.PNG

    At the final .. when i change the K3 value i need to see correspondence values from first sheet.

    Anyone can help me ?
    i attached the table in xlsX format.
    tabel sofer 2.xlsx
    Last edited by STFViata; 04-23-2013 at 05:32 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: help VLOOKUP() OR SOME FORMULAS

    sorry, not exactly sure what you are trying to do

  3. #3
    Forum Contributor
    Join Date
    04-23-2013
    Location
    Abu Dhabi United Arab Emirates
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: help VLOOKUP() OR SOME FORMULAS

    i hope this is the one you looking for, i had attached the file
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-23-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: help VLOOKUP() OR SOME FORMULAS

    Quote Originally Posted by acerrhod View Post
    i hope this is the one you looking for, i had attached the file
    yes it is perfectly , I need some time to be able to implement the project that I have to do
    thank you very much !

  5. #5
    Registered User
    Join Date
    04-23-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: help VLOOKUP() OR SOME FORMULAS

    I need some help :d
    THIS IS WHAT I WANT TO DO :d
    i attached a copy of project

    while

    F5 FROM "PV PALETI" = (B7,B8,B9,B10,B11......B10000) FROM "CENTRALIZATOR PALETI".

    FOR
    (D7,D8,D9,D10 ....D10000)FROM "CENTRALIZATOR PALETI" = "S1"
    WRITE
    I14 FROM "PV PALETI" = F7,F8,F9,F10.....F10000) FROM "CENTRALIZATOR PALETI"
    FOR
    (D7,D8,D9,D10 ....D10000)FROM "CENTRALIZATOR PALETI" = "S2"
    WRITE
    I15 FROM "PV PALETI" = F7,F8,F9,F10.....F10000) FROM "CENTRALIZATOR PALETI"
    FOR
    (D7,D8,D9,D10 ....D10000)FROM "CENTRALIZATOR PALETI" = "S3"
    WRITE
    I16 FROM "PV PALETI" = F7,F8,F9,F10.....F10000) FROM "CENTRALIZATOR PALETI"
    FOR
    (D7,D8,D9,D10 ....D10000)FROM "CENTRALIZATOR PALETI" = "S4"
    WRITE
    I17 FROM "PV PALETI" = F7,F8,F9,F10.....F10000) FROM "CENTRALIZATOR PALETI"
    FOR
    (D7,D8,D9,D10 ....D10000)FROM "CENTRALIZATOR PALETI" = "S5"
    WRITE
    I18 FROM "PV PALETI" = F7,F8,F9,F10.....F10000) FROM "CENTRALIZATOR PALETI"
    FOR
    (D7,D8,D9,D10 ....D10000)FROM "CENTRALIZATOR PALETI" = "S6"
    WRITE
    I19 FROM "PV PALETI" = F7,F8,F9,F10.....F10000) FROM "CENTRALIZATOR PALETI"
    FOR
    (D7,D8,D9,D10 ....D10000)FROM "CENTRALIZATOR PALETI" = "S7"
    WRITE
    I20 FROM "PV PALETI" = F7,F8,F9,F10.....F10000) FROM "CENTRALIZATOR PALETI"


    END :d

    GESTIUNE PALETI - MACRO - PROBE.xlsm

  6. #6
    Registered User
    Join Date
    04-23-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: help VLOOKUP() OR SOME FORMULAS

    nobody , please help me :D

  7. #7
    Forum Contributor
    Join Date
    04-23-2013
    Location
    Abu Dhabi United Arab Emirates
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: help VLOOKUP() OR SOME FORMULAS

    S1, S2, S3.... - this must be in lookup or just assigning the value?

  8. #8
    Registered User
    Join Date
    04-23-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: help VLOOKUP() OR SOME FORMULAS

    hello .

    S1, S2, S3 values ​​are entered manually in " centralizator paleti " sheet .
    i attached again the file .

    GESTIUNE PALETI - MACRO - PROBE.xlsm

  9. #9
    Registered User
    Join Date
    04-23-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: help VLOOKUP() OR SOME FORMULAS

    nobody , please help me :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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