Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Formula Help

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Mike
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What is the formula for limited and specific conditions to return a specific result?
    Example:
    Column A Column B
    (IF)15.90 = 16.02
    (IF)37.50 = 45.48
    . . .
    There are only 11 conditions (prices) for my particular report and percentages will not work because results are based on different conditions (shipping costs, weight, labor, etc.)

  2. #2
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not exactly sure what your attempting to do , though I thing an array formaul will do the trick. If you give me a little better example I might be able to give you the exact array formula required

  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It sounds like you know what the 11 *returns* should be. You might want to create a table on another worksheet, then do a vlookup to that table to have it return the desired value.

    Need help with VLOOKUP? It's ALL over this site if you do a search.

    You can also download a sample VLOOKUP with instructions at:
    http://www.thewordexpert.com/tipwarez.htm#MyVlookup
    ~Anne Troy

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,657
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-05-05 09:05, culprit wrote:
    What is the formula for limited and specific conditions to return a specific result?
    Example:
    Column A Column B
    (IF)15.90 = 16.02
    (IF)37.50 = 45.48
    . . .
    There are only 11 conditions (prices) for my particular report and percentages will not work because results are based on different conditions (shipping costs, weight, labor, etc.)
    =VLOOKUP(A2,{15.90,16.02;37.50,45.48;...},2,0)

    would do. you can even put a 2-column list somewhere, and refer to that list as in

    =VLOOKUP(A2,List,2,0)

    where List the name that you assign to the range of cells that houses the 2-column list.

  5. #5
    New Member
    Join Date
    May 2002
    Location
    Mike
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Many thanks - Aladin Akyurek
    The LOOKUP Array did the job!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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