Forum Discussion

JGA74's avatar
JGA74
Copper Contributor
Aug 25, 2023

Excel formule to check the charter invoice

Please, I need help with an excel formula. I have an Excel file with 3 tabs: Tab1 - my company-DATA; Tab2 - charter bill; Tab3 - Price. The first tab is the information of my company's shipments. ...
excel
Formulas and Functions
JGA74's avatar
JGA74
Copper Contributor
Aug 27, 2023

Hi HansVogelaar 
A question due to lack of knowledge... what means the "+1" in de formule? Why need to be de C6+1

=IF(F6="delivered"; INDEX(tblParcels;C6+1;MATCH(E6;tblParcels[#Headers];0))+(INDEX(tblPallets;D6+1;MATCH(E6;tblPallets[#Headers];0))); "")

This formula works. Thanks. I would like only to understand the +1.

(...)
On the second formula - one of the bill column gave me the message #N/A for some rows..
Is the " #N/A message"  due to the fact that my company's data reference are not in the charter list?


My work computer has Excel for Microsoft 365 MSO (version 2307)

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 27, 2023

    JGA74 

    1) tblParcels and tblPallets begin with 0 parcels and 0 pallets.

    So for example 1 parcel corresponds to the 2nd data row of tblParcels.

     

    2) Might be. Could you provide an example where the formula returns #N/A?

Resources