Nested If Statement + Index/Match with multiple criteria

L

lpost1214

New Member
Joined
Nov 9, 2016
Messages
6
I am trying to populate an open order report with next production dates since our system does not peg production to orders. I am trying write a formula that will meet multiple criteria, but can't seem to get the formula to work just right. Below is a sample of the data and below that the production data and the formula I've written.

Formula: [TABLE="width: 2432"]
<tbody>[TR]
[TD="colspan: 38"]IFERROR(IF(OR(VALUE(g4) > 0,A4=" "),"",IF(AND(VALUE(g4)=0,a3="Description"),VLOOKUP(B4,Sched!A:C,3,0),IF(B4=" ","",IF(AND(VALUE(g4)=0,VALUE(g3) <> 0),INDEX(Sched!C:C,MATCH(Detail!B4,Sched!A:A,0)),IF(AND(VALUE(g4)=0,VALUE(g3)=0,VLOOKUP(B4,Sched!A:C,3,0)-h3 < h4),INDEX(Sched!C:C,MATCH(Detail!B4,Sched!A:A,0)+1),INDEX(Sched!C:C,MATCH(Detail!B4,Sched!A:A,0))))))),"-")[/TD]
[/TR]
</tbody><colgroup><col span="38"></colgroup>[/TABLE]


Criteria:
*If value in balance on hand (column G) = 0, and first row for item (column A) then look up first production quantity for that item.
*If value in balance on hand (column G) = 0, and not first row for item (column A), check to see if production quantity looked up in row above minus the open order qty for the line above, >= open order quantity in the current row. If true, then return the same production quantity as above, if false, return next production quantity for that item.
*If there is no look up value once criteria is met, return a 0
*If an empty row or the value in column G is >0, then show as blank

Thanks in advance for your help!
[TABLE="width: 604"]
<colgroup><col width="180" style="width: 135pt; mso-width-source: userset; mso-width-alt: 6582;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;"> <col width="126" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4608;"> <tbody>[TR]
[TD="class: xl67, width: 180"]Description[/TD]
[TD="class: xl67, width: 107"]Cust PO #[/TD]
[TD="class: xl67, width: 87"]Del Date[/TD]
[TD="class: xl68, width: 64"]Customer PO Quantity[/TD]
[TD="class: xl68, width: 55"]Shipped Qty[/TD]
[TD="class: xl68, width: 65"]Open Order Qty[/TD]
[TD="class: xl66, width: 121, bgcolor: #AEAAAA"]Balance On Hand [/TD]
[TD="class: xl66, width: 126, bgcolor: #AEAAAA"]Next Production Qty[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 604"]
<colgroup><col width="180" style="width: 135pt; mso-width-source: userset; mso-width-alt: 6582;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;"> <col width="126" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4608;"> <tbody>[TR]
[TD="class: xl67, width: 180, bgcolor: transparent"]AS Ultra Trop HBRC 8/3/50[/TD]
[TD="class: xl67, width: 107, bgcolor: transparent"]2171337828[/TD]
[TD="class: xl66, width: 87, bgcolor: transparent"]4/20/2018[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]5417[/TD]
[TD="class: xl67, width: 55, bgcolor: transparent"]0[/TD]
[TD="class: xl67, width: 65, bgcolor: transparent"]5417[/TD]
[TD="class: xl65, width: 121, bgcolor: transparent"]0[/TD]
[TD="class: xl65, width: 126, bgcolor: transparent"]5472[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS Ultra Trop HBRC 8/3/50[/TD]
[TD="class: xl67, bgcolor: transparent"]2171369379[/TD]
[TD="class: xl66, bgcolor: transparent"]6/4/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]5417[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]5417[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]5472[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171328949[/TD]
[TD="class: xl66, bgcolor: transparent"]4/9/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]4750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]4750[/TD]
[TD="class: xl65, bgcolor: transparent"]48[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171369382[/TD]
[TD="class: xl66, bgcolor: transparent"]6/11/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]1425[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]1425[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]1440[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Citracal GEL 12/2/70ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171264847[/TD]
[TD="class: xl66, bgcolor: transparent"]7/6/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2500[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2500[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]1[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Citracal GEL 12/2/70ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171307716[/TD]
[TD="class: xl66, bgcolor: transparent"]8/10/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]1250[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]1250[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]6788[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171259218[/TD]
[TD="class: xl66, bgcolor: transparent"]2/9/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]4106[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]4106[/TD]
[TD="class: xl65, bgcolor: transparent"]3883[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171307607[/TD]
[TD="class: xl66, bgcolor: transparent"]3/12/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2542[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2542[/TD]
[TD="class: xl65, bgcolor: transparent"]1341[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171332469[/TD]
[TD="class: xl66, bgcolor: transparent"]4/11/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2542[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2542[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]11400[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/60ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171259219[/TD]
[TD="class: xl66, bgcolor: transparent"]2/9/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2933[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2933[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]2934[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB GEL 8/3/60ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171307606[/TD]
[TD="class: xl66, bgcolor: transparent"]3/9/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]1467[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]1467[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]1[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171348593[/TD]
[TD="class: xl66, bgcolor: transparent"]3/26/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl65, bgcolor: transparent"]3838[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171348594[/TD]
[TD="class: xl66, bgcolor: transparent"]4/26/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl65, bgcolor: transparent"]88[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171352728[/TD]
[TD="class: xl66, bgcolor: transparent"]5/11/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]3750[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171375520[/TD]
[TD="class: xl66, bgcolor: transparent"]6/15/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]3750[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]3750[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/24ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171366788[/TD]
[TD="class: xl66, bgcolor: transparent"]6/1/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]2083[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]2083[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]3126[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB PM GEL 8/3/24ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171375519[/TD]
[TD="class: xl66, bgcolor: transparent"]6/15/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]1042[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]1042[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]3126[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS Trop HBG RC 8/3/68ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171352178[/TD]
[TD="class: xl66, bgcolor: transparent"]5/24/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]4167[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]4167[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]4210[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl69, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]-[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]AS HB RC Frt 8/3/75ct[/TD]
[TD="class: xl67, bgcolor: transparent"]2171362181[/TD]
[TD="class: xl66, bgcolor: transparent"]5/24/2018[/TD]
[TD="class: xl67, bgcolor: transparent"]4167[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl67, bgcolor: transparent"]4167[/TD]
[TD="class: xl65, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"]4210[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 364"]
<colgroup><col width="209" style="width: 157pt; mso-width-source: userset; mso-width-alt: 7643;"> <col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;"> <col width="162" style="width: 122pt; mso-width-source: userset; mso-width-alt: 5924;"> <tbody>[TR]
[TD="width: 209"]Part Description[/TD]
[TD="width: 113"]Due Date[/TD]
[TD="width: 162"]Production Quantity[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/11/2018[/TD]
[TD="bgcolor: transparent, align: right"]11400[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB GEL 8/3/36ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/1/2018[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB GEL 8/3/60ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/18/2018[/TD]
[TD="bgcolor: transparent, align: right"]2934[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB GEL 8/3/60ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/1/2018[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB PM GEL 8/3/24ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/4/2018[/TD]
[TD="bgcolor: transparent, align: right"]3126[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4/20/2018[/TD]
[TD="bgcolor: transparent, align: right"]3750[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/18/2018[/TD]
[TD="bgcolor: transparent, align: right"]3750[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB PM GEL 8/3/46ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/7/2018[/TD]
[TD="bgcolor: transparent, align: right"]6250[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS HB RC Frt 8/3/75ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/11/2018[/TD]
[TD="bgcolor: transparent, align: right"]4210[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Trop HBG RC 8/3/68ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4/6/2018[/TD]
[TD="bgcolor: transparent, align: right"]4210[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/4/2018[/TD]
[TD="bgcolor: transparent, align: right"]1440[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/25/2018[/TD]
[TD="bgcolor: transparent, align: right"]1920[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Trop HBG RC 8/3/82ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/15/2018[/TD]
[TD="bgcolor: transparent, align: right"]1440[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Ultra Trop HBRC 8/3/50[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4/6/2018[/TD]
[TD="bgcolor: transparent, align: right"]5472[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]AS Ultra Trop HBRC 8/3/50[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5/4/2018[/TD]
[TD="bgcolor: transparent, align: right"]5472[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Citracal GEL 12/2/70ct[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6/8/2018[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
You must log in or register to reply here.

Similar threads

S
  • Question Question
Multiple Condition IF/OR Statement with TEXT
Replies
1
Views
989
AlanY
A
N
  • Question Question
How to Create Multiple Reports from One Sheet
Replies
1
Views
2K
Logit
Logit
subrosumon
  • Question Question
Multiple Sheet pivot table
Replies
1
Views
838
steve the fish
steve the fish
G
  • Question Question
Transpose matching data from columns to rows
Replies
3
Views
857
bwaaack
B
M
  • Question Question
Index Match formula with multiple criteria
Replies
5
Views
781
DanteAmor
DanteAmor

Forum statistics

Threads
1,223,905
Messages
6,175,297
Members
452,633
Latest member
DougMo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top