- =VLOOKUP(A2,MDM!$A$2:$A$308971,1,FALSE)
- Argument 1 -> lookup value
- Argument 2 -> Table array. Note: if it is different sheet then SheetName!Table array
- Argument 3 -> Column index to compare
- Argument 4 -> FALSE (Looking for exact match)
Tuesday, August 6, 2024
vlookup in excel
Subscribe to:
Posts (Atom)
Disabling the flight in D365FO (CHD - Tier 1)
INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED) VALUES ('<FlightObjectName>_KillSwitch', 1) or INSERT INTO dbo.SYSFLIGHT...
-
Posting Vendor invoice based on Product receipt public void postPurchaseInvoiceJournal() { VendPackingSlipJour vendP...
-
Restore .bacpac file to Development VM Steps: 1. Take Backup of AxDB database from Development VM 2. Open Command Pr...
-
BP: BPUpgradeCodeLateBoundCall : BP Rule: [BPUpgradeCodeLateBoundCall]:A late bound call callingForm.refresh is made. In source system (...