+ Reply to Thread
Results 1 to 5 of 5

Function PROCV with 2 references HELP

  1. #1
    Registered User
    Join Date
    06-23-2014
    Location
    PT
    MS-Off Ver
    2010
    Posts
    17

    Function PROCV with 2 references HELP

    I need to make a table where I put the ref. and the desired color and then show me the corrected price.

    I have atached the file

    If could someone help me i will be much apreciated, or if me send an example

    I only can do the search with one reference

    Thanks

    Filipe
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,373

    Re: Function PROCV with 2 references HELP

    Not clear about the expected results, let me clarify:

    Condition 1=for example "AXi-01"

    and what Condition 2 ? Is it "ACETINADO" and "2 AC" in color area, and if match, the results is 8.00

    Is that correct result?

  3. #3
    Registered User
    Join Date
    06-23-2014
    Location
    PT
    MS-Off Ver
    2010
    Posts
    17

    Re: Function PROCV with 2 references HELP

    The condition 1 is ex axi-01 (gren color)
    and the condition 2 will be all the colours(in yellow colour).


    So if we choose "axi-01" in colour "2 AC" the price is 8.00

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,373

    Re: Function PROCV with 2 references HELP

    Perhaps something like this? Using Array Formula (need press CTRL-SHIFT-ENTER button together)
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-23-2014
    Location
    PT
    MS-Off Ver
    2010
    Posts
    17

    Re: Function PROCV with 2 references HELP

    thank you very much azumi. is that i was looking for.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct Function with Other Function References
    By T86157 in forum Outlook Formatting & Functions
    Replies: 4
    Last Post: 07-30-2012, 04:56 PM
  2. IF Function that references web page
    By spursrule68 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-01-2012, 07:27 AM
  3. SE and PROCV
    By Birnen in forum Non English Excel
    Replies: 7
    Last Post: 08-12-2010, 12:35 PM
  4. some small ajustment...in procv function.
    By x-plicit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2010, 09:43 AM
  5. Excel 2007 : Non-Contiguous Function References
    By SDruley in forum Excel General
    Replies: 7
    Last Post: 05-06-2009, 04:37 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