a/c

Hi, i have this table and this formula, =INDEX(Sheet1!D2:D4,MATCH(Sheet1!C2,Sheet1!C2:C4,0)*MATCH(Sheet1!A2,Sheet1!A2:A4,0)) <tbody> ID DESC A/C # AMT 133888 VOICE 8883 545 100300 IP 9833 800 100358 INTERNET #N/A </tbody> how can modify it that if a/c # is blank still get the amount...

<tbody> Item 260 A/C 2121 Date failed: 15 May Fault: B60 Item 260 A/C 2121 7 May B60 Item 260 A/C 2003 3 May B60/CS Item 260 A/C 2103 6 Jul B60 </tbody> I'm trying to build a table that pulls from another automatically and checks to see if my equipment items have failed...

<tbody> SAVING A/C COMISSION AMOUNT FD A/C COMISSION AMOUNT 10 0 10 0 25 400 25 400 35 0 35 0 50 400 50 900 65 0 65 0 70 0 70 0 75 400 75 1500 </tbody> THIS SALE COMMISSION TABLE OF BANK 1.) IN FIRST TABLE HOW COMMISSION REFLECT SAME IN "COMMISSION AMOUNT COLUMN" WHEN...

I have the following array formula below, which gives me the correct result =INDEX(D:D,MATCH(1,SEARCH("Grand*",A:A))) ]/code] Alt+Shift+enter I have tried add text to this, but get message opening or closing Parenthesis missing [code] ="The Balance on a/c 975415 is...

I have a table that looks like this: <colgroup><col></colgroup><tbody> AL INC.(CCML) EX, LLC (FF) TG & A/C (B-FF) JING & A/C (B-FF) OKA (B-FF) EATING & A/C,INC(B-GA) MECHANICAL AIR SYSTEMS INC </tbody> I need to be able to identify the B or the C in the parenthesis of each and...

Hi everyone, i would like to enter the description "Occupancy" below NET PROFIT / LOSS using a vba code. Please note that the rows are not stable. The Schedule 1. shows the original data and schedule 2. is the expected result. Many thanks in advance Schedule 1. <tbody> A 1 Income 2...