|
|
#1
11-29-2019, 04:14 AM
|
|||
|
|||
Multiple criterias search in a table
Hi all.
I guess that it was already discussed but I cannot find them.  There is a table: # Ref Ref BreakPoint A 1 10 A 5 9 B 1 1 B 14 0.2 When you buy 2 units of the reference A the price is 10 When you buy 8 units of the reference A the price is 9 What formula should I use to have automatically the right price when I put the reference and the quantity?  Thanks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Search through multiple sheets with multiple textboxes | andxie | Excel Programming | 0 | 07-09-2018 07:04 PM |
 VBA Table Search All Tables - Find & Replace Text in Table Cell With Specific Background Color
|
jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
| formula to find 2 or more criterias then average the sum | samtitus | Excel | 6 | 02-17-2014 10:16 PM |
|
SUMIF/SUMPRODUCT across multiple sheets/Criterias
|
lukeyb_11 | Excel | 1 | 02-14-2014 10:30 AM |
|
Mail Merge to print specific record based on mergefield criterias
|
nicnad | Mail Merge | 1 | 02-22-2012 01:53 AM |
Windows 7 64bit 
Office 2007
Threaded Mode