Pulling first non blank cell per item ID

[stapler88]

<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @Page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:windowtext; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {color:black; font-size:14.0pt; font-family:"Helvetica Neue", sans-serif; mso-font-charset:0;} .xl64 {color:black;} --> </style>[TABLE="width: 87"]
<!--StartFragment--> <colgroup><col width="87" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 87"]Hi I'm trying pull the first non blank value as my dates go from right to left on a count sheet.[/TD]
[/TR]
[TR]
[TD="class: xl63"]I need to pull the last count regardless of date into Table B as the first non blank value for that SKU. Data is coming from Table A.[/TD]
[/TR]
[TR]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl63"]When I use the following equation it's pulling in the SKU as that is technically the first non blank value. Date does not matter just the first non blank value for that SKU. New column will always be in column C.[/TD]
[/TR]
[TR]
[TD="class: xl63"]INDEX('Physical Counts'!1:180,MATCH(A2,'Physical Counts'!AD:AD,0),MATCH(FALSE,ISBLANK('Physical Counts'!2:2),0))[/TD]
[/TR]
[TR]
[TD="class: xl63"]Thanks![/TD]
[/TR]
[TR]
[TD="class: xl64"]
Table A[/TD]
[/TR]
[TR]
[TD="class: xl63"]<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @Page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl65 {border:.5pt solid windowtext;} .xl66 {mso-number-format:"d\\-mmm"; border:.5pt solid windowtext;} --> </style>[TABLE="width: 435"]
<!--StartFragment--> <colgroup><col width="87" span="5" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 87"]SKU[/TD]
[TD="class: xl65, width: 87"]Description[/TD]
[TD="class: xl66, width: 87, align: right"]16-Nov[/TD]
[TD="class: xl66, width: 87, align: right"]15-Nov[/TD]
[TD="class: xl66, width: 87, align: right"]14-Nov[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]111[/TD]
[TD="class: xl65"]Apple[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD="class: xl65, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]112[/TD]
[TD="class: xl65"]Orange[/TD]
[TD="class: xl65, align: right"]3[/TD]
[TD="class: xl65, align: right"]2[/TD]
[TD="class: xl65, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]113[/TD]
[TD="class: xl65"]Banana[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65, align: right"]8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Table B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]SKU[/TD]
[TD="class: xl65"]Description[/TD]
[TD="class: xl65"]Last count[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]111[/TD]
[TD="class: xl65"]Apple[/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]112[/TD]
[TD="class: xl65"]Orange[/TD]
[TD="class: xl65, align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]113[/TD]
[TD="class: xl65"]Banana[/TD]
[TD="class: xl65, align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]
[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]

 

[anglais428]

If Table A is in range A1:E4, then for Apple the formula will be =INDEX($C$2:$E$4,MATCH(B12,$B$2:$B$4,0),MATCH(TRUE, INDEX(ISNUMBER(C2:E2),0),0))
B12 is the call where I had the Word "Apple" in Table B.
Fill down for Orange and Banana.

Adjust the cell ranges to suit your file.