Hi,
If I have the following formulas which I want to be converted to VB:
=IFERROR<gs id="95146ea2-a868-48a9-ae4e-38655265a7ef" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="43a721d8-bb43-4ef1-b2ed-b7cd3e25e3b2" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">(</gs></gs>INDEX<gs id="4c1ba51e-4a66-42b8-a1ec-a452e706dbdf" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="6d348e75-9dc4-48b3-bfa5-297bf8fd28b6" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">(</gs></gs><gs id="f842e6a5-d432-49fa-beae-feb7b1a086c7" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="2ce7fb12-912d-42e9-925a-0535a3cb88bc" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">stockitems</gs></gs><gs id="b8637d2c-f19f-4f08-8ac2-3c099344a6e9" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="0b46b93d-63ec-4b7a-8f8e-2722019b05c3" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">!</gs></gs>$C$2<gs id="6cff985d-2f46-49b2-b86e-aec1cf777183" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="5dafba52-3f23-4dc9-9365-05611a0f7af4" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">:</gs></gs>$C$5001<gs id="451d023b-81ec-4eed-a28c-fee0f2b0f858" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="6d94d172-e107-44b4-a0d9-4d8ac7e83006" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="d2c55d76-29e2-47a3-b252-7fda54ce7cfa" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="266a0d38-5834-466b-9b3e-3aac4105bc81" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">(</gs></gs>J1220<gs id="c01f4e14-86ac-4fb0-82a8-022b0dfa6fda" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="eb02ae4c-1e4f-4ded-aeae-de8e04a3d25e" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">,</gs></gs><gs id="11c04fc1-dbbc-423f-ad3c-235c939ce3dc" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="221be7c6-08ce-4cdc-8916-2de416471374" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">stockitems</gs></gs><gs id="54b0c9c0-bad3-42d8-968d-545cf88e4ca5" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="c457c71e-111a-408d-9d0a-530c167af8f8" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">!</gs></gs>$A$2<gs id="c4f03263-a495-4df9-84bf-697f2b8c60be" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="e38ea647-4edd-4af8-a27a-16eaeb1b5f18" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">:</gs></gs>$A$5001<gs id="4f67c446-770d-4b0a-9618-341bec12a404" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="bb5b22c2-523e-43d1-b215-053877f7f08c" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE)<gs id="dfc96c83-05b7-49eb-9bf7-6dec4619292c" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="b5b9ef9a-280a-42d9-b015-9c19e19bb405" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">,</gs></gs>1),"")
=IFERROR<gs id="8c3d695b-c2ae-4827-bebc-815904d6a3af" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="ccd15f72-4757-4c07-af2c-225a4ec8651f" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>IF<gs id="e14f3ff1-11f0-4180-8546-63ac3bfb8194" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="c2d4efc5-6b74-4384-a075-91f338387fbb" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>Q1220="X0","OT14"<gs id="5e99eb77-5496-4db1-8ca6-e36887cc1419" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="bae3ac62-f42d-4fcc-9c0c-75c660f96306" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>IF<gs id="61f1fa5d-8411-484f-91f1-1d6524a572ab" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="568ac6ca-faa0-4992-ab62-a02ad828a96a" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>Q1220="OVAT-N"<gs id="0c25656c-871a-42d4-af97-962676a29ca3" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="7642854f-dd85-4657-b3bc-be65900ce891" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>INDEX<gs id="5ae5a7b6-76e1-451b-9c98-053c4ab0c506" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="0f64145f-5384-4743-91ee-1de9ae26a654" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>'Master Data'<gs id="102d88af-f775-4d08-8f49-2e238dc614a6" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="69612362-a129-4b48-b837-b7ef74170b4c" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">!</gs></gs>$AE$5<gs id="729753a7-e24f-439d-9668-d9571c4ed235" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="1f55fb48-9a46-437c-8e42-74cf6a0e1154" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">:</gs></gs>$AE$5000<gs id="02c8f04b-e635-43b4-90e8-55cdf095515f" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="49e16fed-fc5f-4ea0-bfb3-44afa448a7a8" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="e451ad80-df9a-4385-a809-63b05e41ec99" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="4f2e49c4-d955-4c6f-b2d5-76e2b8e2608f" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>J1220,'Master Data'<gs id="45e37611-3a3f-4c78-9223-58497352d126" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="fdc1d4c3-ab76-4df7-984c-2efdb03c595e" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">!</gs></gs>$AL$5<gs id="7898af4b-7138-4997-870a-1c8528f2590f" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="b3b552ac-95e3-4a7c-acb5-7cbdf58a7248" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">:</gs></gs>$AL$5000<gs id="5ce5ff78-ce3c-4f8f-81a8-3adafda95e75" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="0daf30b6-2e0f-49f7-bf5c-27331385ca84" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE)<gs id="1e3eb89d-1ea2-408f-addc-6e8c606d8f68" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="447f5a19-37a3-49b4-af9a-d352ee1b0db5" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>1),"")),"")
=IFERROR<gs id="dd8ecf75-f51f-4ec1-a359-112e7e105053" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="f778cd16-acee-4d65-8b41-164375db223e" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>(INDEX<gs id="5c148632-33ac-4390-9a28-b4267cac30df" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="d7e41f8e-8975-4452-9a48-bc52788ef43c" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>'Unit Price Pivot'<gs id="b37f828a-c408-4423-aa54-ee02772a3bba" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="b6d765fe-345b-47b2-8fe9-d39b6722c8de" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>F$2<gs id="219fc645-250b-44e5-b8f3-ff9ecf133da5" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="d0d08689-13af-47df-bda9-3890bde827c2" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>F$15000<gs id="cdeda3c3-a049-4c35-a353-48a64feedb43" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="388b2eb1-d050-4d6e-a573-4d7bdea28c21" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="b7ba99ce-65a6-4887-9544-5f89bcfc3f2c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="62571a63-e723-4bbd-a29c-124543f572e3" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>1<gs id="1dd69ffa-886a-47b6-b1b4-dd59b14364be" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="438ab802-8882-46cc-bbe9-4887a2f1e369" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>INDEX<gs id="d0c9a491-76e6-4fe5-9ffe-c3e5c3aa243c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="029a3227-d34c-450f-b3f0-421bdc7bdbf9" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>('Unit Price Pivot'<gs id="15ae41ec-facd-4c03-a5ba-4e5958c69d20" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="40c80d28-c677-4cbc-9ea5-e787492809c1" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$B$2<gs id="9a3dbd41-e295-49e8-8471-434444f7434f" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="5077babe-ccce-419a-b8d7-1db8c179ea66" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$B$15000=U1220<gs id="40b4b44c-6b1d-4aa5-8993-86ada7e1ad0e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="43abaa7a-0d43-4055-8638-3a87a9c2a6a7" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">)</gs></gs>*<gs id="295cb19b-8298-4ef8-86aa-13291cc0b524" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="16bc95e6-5233-4fdc-9d13-b578700c5f63" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>'Unit Price Pivot'<gs id="e594f272-d15e-41ae-8d05-1b00c259ba99" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="4aceae23-5df8-4038-a8ee-a2d7ddcd648b" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$H$2<gs id="92f555df-04f1-4865-a824-26e443711a08" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="f4fb856d-9603-4f43-9c15-d6610bf3b156" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$H$15000=T1220<gs id="0c493d6e-2528-48f1-bf52-b6cd93b91595" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="ea3f1b0c-798e-4d28-9e97-50830b96ff24" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">)</gs></gs>*<gs id="3aaaad3e-c84f-46c4-ae14-5cb922a66ca1" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="a73d1e3e-aa5f-4a0e-93c4-6e901f21361b" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>'Unit Price Pivot'<gs id="178d055c-3831-4f15-b704-df4ed1fbbab4" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="358dff6f-80a9-4acb-a5dd-0e5bb9bef97e" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$H$2<gs id="4b1bbf51-5521-4790-a76a-1e47d7ce3cff" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="4d6ff97e-1e64-410a-a3c6-bfc7757d52f5" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$H$15000=T1220),)<gs id="1307df45-c7ba-433a-88c8-aadbc794d589" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="8b42ca9e-77e9-46b9-a03d-fe24b40edb9c" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE))<gs id="a642d287-15e4-46d8-bb88-fcd9b27e012a" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="49b47283-f067-4c3c-bee7-1a5c2bb6b742" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">)</gs></gs>*<gs id="fced371f-f690-48ce-9b91-ba81577cffbc" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="7dd74536-b9ff-4a72-9815-739aa4f37a71" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>INDEX<gs id="0bfebc58-6cc8-4f54-8dd8-d7ff01e1225e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="28e1f615-0e98-4e34-b851-741cc68fac4f" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs><gs id="5a93fc4d-586e-4e3a-9b71-49126bc5da5c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="84617cac-a8bb-4a50-a16d-82ce445c3ee9" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">stockitems</gs></gs><gs id="448c495c-ce46-48dc-a9a6-bbc34ee945b2" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="1c5dbb7e-e962-4bca-9027-817875903b98" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$AV$2<gs id="ed871f1b-3ce7-4f2f-8da3-c812b78af02e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="4b000641-97a7-4862-91f3-b33d85c0f00b" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$AV$5000<gs id="77c2a977-f01e-4306-a4b7-ade2eb978569" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="7e3ff10f-374d-4ec4-a08e-adf85b0bb09a" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="fc781107-c554-49f2-b01d-f1f0dbabd5dc" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="113f957f-eca1-4335-9a04-14b42e46d843" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>U1220<gs id="9bfc687c-1ca1-4c58-930a-6223ef7eb41c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="20cd61d4-e16c-4958-9213-f60ed6328750" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs><gs id="34c00567-d60e-43ee-bb31-3dbb2b67e900" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="2ec2be0d-cf0d-4fd0-a1bb-aa3b433f5b44" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">stockitems</gs></gs><gs id="8973d174-ef1a-482a-83b1-5e86f4f489df" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="57002221-52d6-4d70-972c-8df178889bf1" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$B$2<gs id="ac1a00f4-3e90-4ea1-a14d-877a36858461" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="5811ac22-408d-4230-9792-ac112ee433c3" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$B$5000<gs id="bf4da1d7-2c9c-473c-adda-19c3ca286b06" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="f5ae5b6b-008a-4a2f-970e-6f5003f72f99" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE)<gs id="08fb1327-44ee-4318-9b80-c47a9935a94a" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="c2d917c9-c97c-49c6-b670-10f4e85b76af" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>1)<gs id="6d133b1b-083d-4644-aa6e-04090f89eb8c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="028b214d-db38-436e-a249-1773018c47b8" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">)</gs></gs>/(INDEX<gs id="77618bf5-a611-41db-9546-8a3f64ad8a4e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="1017a9c8-9aa0-4d81-a5b9-c97781d17232" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>'Master Data'<gs id="100f0f4c-7064-4247-9e21-a82911c4d787" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="f93723d2-73ca-48bb-a7f1-5adad1caa3a8" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$BA$5<gs id="52da6773-bd12-4fbf-85b8-e643d2a92628" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="7ed57ff0-81b1-4230-854e-fb8f4cd01894" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$BA$5000<gs id="5e88d40e-f3fb-4069-9be1-f6bb47b25e32" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="efe22782-8b7c-451e-a8c7-c4a018b32177" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="be9ad591-0c3f-4393-b5a3-8c00b6a13f5e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="92c19682-f727-4ea1-9d0c-89d162c21fe3" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>U1220,'Master Data'<gs id="5f0bc4e3-9693-4eeb-bd90-78c2ffa65179" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="31ced21e-869c-42df-9520-2e9fccaed208" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$A$5<gs id="158d7490-b21f-4a62-8ee8-ca9c62895d00" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="c0a60d7b-6f90-4979-8a37-a4011f8a8650" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$A$5000<gs id="60f5e39b-6c39-46ce-8b7c-1341435be4da" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="15bfa167-8bc9-4d0b-a5e5-c0bb815c6322" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE)<gs id="074f1c75-4afb-40f8-95c6-8fb65ca62815" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="6eaa8e83-efee-441c-bf36-643c39e13be9" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>1)),"")
=IF(OR(C1214<>C1213,H1214<>H1213),D1213+1,D1213)
Please be advised that I am a NEW <gs id="f4e50397-4fda-4ed4-813d-93cd7e53aff2" ginger_software_uiphraseguid="68a80da2-3bf5-443e-8a52-eea1933f2fb3" class="GINGER_SOFTWARE_mark"><gs id="1f7864d0-130a-4b1a-bb83-a5568cb51e81" ginger_software_uiphraseguid="51f0fbf1-ea4a-42c9-8aae-e81d9ba5493c" class="GINGER_SOFTWARE_mark">vb</gs></gs> user, so I totally have zero idea on how to write them
Thank you
If I have the following formulas which I want to be converted to VB:
=IFERROR<gs id="95146ea2-a868-48a9-ae4e-38655265a7ef" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="43a721d8-bb43-4ef1-b2ed-b7cd3e25e3b2" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">(</gs></gs>INDEX<gs id="4c1ba51e-4a66-42b8-a1ec-a452e706dbdf" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="6d348e75-9dc4-48b3-bfa5-297bf8fd28b6" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">(</gs></gs><gs id="f842e6a5-d432-49fa-beae-feb7b1a086c7" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="2ce7fb12-912d-42e9-925a-0535a3cb88bc" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">stockitems</gs></gs><gs id="b8637d2c-f19f-4f08-8ac2-3c099344a6e9" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="0b46b93d-63ec-4b7a-8f8e-2722019b05c3" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">!</gs></gs>$C$2<gs id="6cff985d-2f46-49b2-b86e-aec1cf777183" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="5dafba52-3f23-4dc9-9365-05611a0f7af4" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">:</gs></gs>$C$5001<gs id="451d023b-81ec-4eed-a28c-fee0f2b0f858" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="6d94d172-e107-44b4-a0d9-4d8ac7e83006" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="d2c55d76-29e2-47a3-b252-7fda54ce7cfa" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="266a0d38-5834-466b-9b3e-3aac4105bc81" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">(</gs></gs>J1220<gs id="c01f4e14-86ac-4fb0-82a8-022b0dfa6fda" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="eb02ae4c-1e4f-4ded-aeae-de8e04a3d25e" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">,</gs></gs><gs id="11c04fc1-dbbc-423f-ad3c-235c939ce3dc" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="221be7c6-08ce-4cdc-8916-2de416471374" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">stockitems</gs></gs><gs id="54b0c9c0-bad3-42d8-968d-545cf88e4ca5" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="c457c71e-111a-408d-9d0a-530c167af8f8" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">!</gs></gs>$A$2<gs id="c4f03263-a495-4df9-84bf-697f2b8c60be" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="e38ea647-4edd-4af8-a27a-16eaeb1b5f18" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">:</gs></gs>$A$5001<gs id="4f67c446-770d-4b0a-9618-341bec12a404" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="bb5b22c2-523e-43d1-b215-053877f7f08c" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE)<gs id="dfc96c83-05b7-49eb-9bf7-6dec4619292c" ginger_software_uiphraseguid="76141d8d-df9e-4742-93b4-029619e529bb" class="GINGER_SOFTWARE_mark"><gs id="b5b9ef9a-280a-42d9-b015-9c19e19bb405" ginger_software_uiphraseguid="4ef54256-8e9c-4394-8f0a-9b5825ffa9f6" class="GINGER_SOFTWARE_mark">,</gs></gs>1),"")
=IFERROR<gs id="8c3d695b-c2ae-4827-bebc-815904d6a3af" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="ccd15f72-4757-4c07-af2c-225a4ec8651f" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>IF<gs id="e14f3ff1-11f0-4180-8546-63ac3bfb8194" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="c2d4efc5-6b74-4384-a075-91f338387fbb" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>Q1220="X0","OT14"<gs id="5e99eb77-5496-4db1-8ca6-e36887cc1419" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="bae3ac62-f42d-4fcc-9c0c-75c660f96306" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>IF<gs id="61f1fa5d-8411-484f-91f1-1d6524a572ab" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="568ac6ca-faa0-4992-ab62-a02ad828a96a" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>Q1220="OVAT-N"<gs id="0c25656c-871a-42d4-af97-962676a29ca3" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="7642854f-dd85-4657-b3bc-be65900ce891" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>INDEX<gs id="5ae5a7b6-76e1-451b-9c98-053c4ab0c506" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="0f64145f-5384-4743-91ee-1de9ae26a654" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>'Master Data'<gs id="102d88af-f775-4d08-8f49-2e238dc614a6" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="69612362-a129-4b48-b837-b7ef74170b4c" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">!</gs></gs>$AE$5<gs id="729753a7-e24f-439d-9668-d9571c4ed235" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="1f55fb48-9a46-437c-8e42-74cf6a0e1154" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">:</gs></gs>$AE$5000<gs id="02c8f04b-e635-43b4-90e8-55cdf095515f" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="49e16fed-fc5f-4ea0-bfb3-44afa448a7a8" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="e451ad80-df9a-4385-a809-63b05e41ec99" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="4f2e49c4-d955-4c6f-b2d5-76e2b8e2608f" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">(</gs></gs>J1220,'Master Data'<gs id="45e37611-3a3f-4c78-9223-58497352d126" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="fdc1d4c3-ab76-4df7-984c-2efdb03c595e" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">!</gs></gs>$AL$5<gs id="7898af4b-7138-4997-870a-1c8528f2590f" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="b3b552ac-95e3-4a7c-acb5-7cbdf58a7248" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">:</gs></gs>$AL$5000<gs id="5ce5ff78-ce3c-4f8f-81a8-3adafda95e75" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="0daf30b6-2e0f-49f7-bf5c-27331385ca84" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE)<gs id="1e3eb89d-1ea2-408f-addc-6e8c606d8f68" ginger_software_uiphraseguid="168bfb08-9785-4935-954e-07dd428e1094" class="GINGER_SOFTWARE_mark"><gs id="447f5a19-37a3-49b4-af9a-d352ee1b0db5" ginger_software_uiphraseguid="e0bf5897-8eb0-4570-966b-2b3a5cae5429" class="GINGER_SOFTWARE_mark">,</gs></gs>1),"")),"")
=IFERROR<gs id="dd8ecf75-f51f-4ec1-a359-112e7e105053" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="f778cd16-acee-4d65-8b41-164375db223e" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>(INDEX<gs id="5c148632-33ac-4390-9a28-b4267cac30df" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="d7e41f8e-8975-4452-9a48-bc52788ef43c" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>'Unit Price Pivot'<gs id="b37f828a-c408-4423-aa54-ee02772a3bba" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="b6d765fe-345b-47b2-8fe9-d39b6722c8de" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>F$2<gs id="219fc645-250b-44e5-b8f3-ff9ecf133da5" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="d0d08689-13af-47df-bda9-3890bde827c2" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>F$15000<gs id="cdeda3c3-a049-4c35-a353-48a64feedb43" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="388b2eb1-d050-4d6e-a573-4d7bdea28c21" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="b7ba99ce-65a6-4887-9544-5f89bcfc3f2c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="62571a63-e723-4bbd-a29c-124543f572e3" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>1<gs id="1dd69ffa-886a-47b6-b1b4-dd59b14364be" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="438ab802-8882-46cc-bbe9-4887a2f1e369" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>INDEX<gs id="d0c9a491-76e6-4fe5-9ffe-c3e5c3aa243c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="029a3227-d34c-450f-b3f0-421bdc7bdbf9" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>('Unit Price Pivot'<gs id="15ae41ec-facd-4c03-a5ba-4e5958c69d20" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="40c80d28-c677-4cbc-9ea5-e787492809c1" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$B$2<gs id="9a3dbd41-e295-49e8-8471-434444f7434f" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="5077babe-ccce-419a-b8d7-1db8c179ea66" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$B$15000=U1220<gs id="40b4b44c-6b1d-4aa5-8993-86ada7e1ad0e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="43abaa7a-0d43-4055-8638-3a87a9c2a6a7" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">)</gs></gs>*<gs id="295cb19b-8298-4ef8-86aa-13291cc0b524" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="16bc95e6-5233-4fdc-9d13-b578700c5f63" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>'Unit Price Pivot'<gs id="e594f272-d15e-41ae-8d05-1b00c259ba99" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="4aceae23-5df8-4038-a8ee-a2d7ddcd648b" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$H$2<gs id="92f555df-04f1-4865-a824-26e443711a08" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="f4fb856d-9603-4f43-9c15-d6610bf3b156" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$H$15000=T1220<gs id="0c493d6e-2528-48f1-bf52-b6cd93b91595" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="ea3f1b0c-798e-4d28-9e97-50830b96ff24" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">)</gs></gs>*<gs id="3aaaad3e-c84f-46c4-ae14-5cb922a66ca1" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="a73d1e3e-aa5f-4a0e-93c4-6e901f21361b" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>'Unit Price Pivot'<gs id="178d055c-3831-4f15-b704-df4ed1fbbab4" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="358dff6f-80a9-4acb-a5dd-0e5bb9bef97e" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$H$2<gs id="4b1bbf51-5521-4790-a76a-1e47d7ce3cff" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="4d6ff97e-1e64-410a-a3c6-bfc7757d52f5" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$H$15000=T1220),)<gs id="1307df45-c7ba-433a-88c8-aadbc794d589" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="8b42ca9e-77e9-46b9-a03d-fe24b40edb9c" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE))<gs id="a642d287-15e4-46d8-bb88-fcd9b27e012a" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="49b47283-f067-4c3c-bee7-1a5c2bb6b742" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">)</gs></gs>*<gs id="fced371f-f690-48ce-9b91-ba81577cffbc" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="7dd74536-b9ff-4a72-9815-739aa4f37a71" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>INDEX<gs id="0bfebc58-6cc8-4f54-8dd8-d7ff01e1225e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="28e1f615-0e98-4e34-b851-741cc68fac4f" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs><gs id="5a93fc4d-586e-4e3a-9b71-49126bc5da5c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="84617cac-a8bb-4a50-a16d-82ce445c3ee9" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">stockitems</gs></gs><gs id="448c495c-ce46-48dc-a9a6-bbc34ee945b2" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="1c5dbb7e-e962-4bca-9027-817875903b98" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$AV$2<gs id="ed871f1b-3ce7-4f2f-8da3-c812b78af02e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="4b000641-97a7-4862-91f3-b33d85c0f00b" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$AV$5000<gs id="77c2a977-f01e-4306-a4b7-ade2eb978569" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="7e3ff10f-374d-4ec4-a08e-adf85b0bb09a" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="fc781107-c554-49f2-b01d-f1f0dbabd5dc" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="113f957f-eca1-4335-9a04-14b42e46d843" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>U1220<gs id="9bfc687c-1ca1-4c58-930a-6223ef7eb41c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="20cd61d4-e16c-4958-9213-f60ed6328750" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs><gs id="34c00567-d60e-43ee-bb31-3dbb2b67e900" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="2ec2be0d-cf0d-4fd0-a1bb-aa3b433f5b44" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">stockitems</gs></gs><gs id="8973d174-ef1a-482a-83b1-5e86f4f489df" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="57002221-52d6-4d70-972c-8df178889bf1" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$B$2<gs id="ac1a00f4-3e90-4ea1-a14d-877a36858461" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="5811ac22-408d-4230-9792-ac112ee433c3" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$B$5000<gs id="bf4da1d7-2c9c-473c-adda-19c3ca286b06" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="f5ae5b6b-008a-4a2f-970e-6f5003f72f99" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE)<gs id="08fb1327-44ee-4318-9b80-c47a9935a94a" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="c2d917c9-c97c-49c6-b670-10f4e85b76af" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>1)<gs id="6d133b1b-083d-4644-aa6e-04090f89eb8c" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="028b214d-db38-436e-a249-1773018c47b8" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">)</gs></gs>/(INDEX<gs id="77618bf5-a611-41db-9546-8a3f64ad8a4e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="1017a9c8-9aa0-4d81-a5b9-c97781d17232" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>'Master Data'<gs id="100f0f4c-7064-4247-9e21-a82911c4d787" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="f93723d2-73ca-48bb-a7f1-5adad1caa3a8" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$BA$5<gs id="52da6773-bd12-4fbf-85b8-e643d2a92628" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="7ed57ff0-81b1-4230-854e-fb8f4cd01894" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$BA$5000<gs id="5e88d40e-f3fb-4069-9be1-f6bb47b25e32" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="efe22782-8b7c-451e-a8c7-c4a018b32177" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>MATCH<gs id="be9ad591-0c3f-4393-b5a3-8c00b6a13f5e" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="92c19682-f727-4ea1-9d0c-89d162c21fe3" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">(</gs></gs>U1220,'Master Data'<gs id="5f0bc4e3-9693-4eeb-bd90-78c2ffa65179" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="31ced21e-869c-42df-9520-2e9fccaed208" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">!</gs></gs>$A$5<gs id="158d7490-b21f-4a62-8ee8-ca9c62895d00" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="c0a60d7b-6f90-4979-8a37-a4011f8a8650" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">:</gs></gs>$A$5000<gs id="60f5e39b-6c39-46ce-8b7c-1341435be4da" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="15bfa167-8bc9-4d0b-a5e5-c0bb815c6322" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>FALSE)<gs id="074f1c75-4afb-40f8-95c6-8fb65ca62815" ginger_software_uiphraseguid="f2c739ee-3630-4ace-b704-af9cd39d5c0e" class="GINGER_SOFTWARE_mark"><gs id="6eaa8e83-efee-441c-bf36-643c39e13be9" ginger_software_uiphraseguid="9ffd2d18-2bf6-485b-b53f-b3a38806ff08" class="GINGER_SOFTWARE_mark">,</gs></gs>1)),"")
=IF(OR(C1214<>C1213,H1214<>H1213),D1213+1,D1213)
Please be advised that I am a NEW <gs id="f4e50397-4fda-4ed4-813d-93cd7e53aff2" ginger_software_uiphraseguid="68a80da2-3bf5-443e-8a52-eea1933f2fb3" class="GINGER_SOFTWARE_mark"><gs id="1f7864d0-130a-4b1a-bb83-a5568cb51e81" ginger_software_uiphraseguid="51f0fbf1-ea4a-42c9-8aae-e81d9ba5493c" class="GINGER_SOFTWARE_mark">vb</gs></gs> user, so I totally have zero idea on how to write them
Thank you
Last edited:
