Thanks:  0
Likes:  0

1. 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. 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. 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.

http://www.thewordexpert.com/tipwarez.htm#MyVlookup

4. 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. Many thanks - Aladin Akyurek
The LOOKUP Array did the job!

## User Tag List

#### Posting Permissions

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