Formula Help

culprit · May 5th, 2002, 10:05 AM

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

Nimrod · May 5th, 2002, 10:10 AM

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

Anne Troy · May 5th, 2002, 10:12 AM

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

Aladin Akyurek · May 5th, 2002, 10:13 AM

Quote:

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.

culprit · May 5th, 2002, 11:16 AM

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

May 5th, 2002, 10:12 AM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 5th, 2002, 10:05 AM	#1
culprit New Member Join Date: May 2002 Location: Mike Posts: 2	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.)

May 5th, 2002, 10:10 AM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	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

May 5th, 2002, 11:16 AM	#5
culprit New Member Join Date: May 2002 Location: Mike Posts: 2	Many thanks - Aladin Akyurek The LOOKUP Array did the job!