Forum Discussion

marietuttle1973's avatar
marietuttle1973
Brass Contributor
Aug 02, 2024

Formula to autofill a PO #

I have a workbook with 2 sheets. Sheet 1, column A is where the formula needs to go - based off the information in the sheet called Customer list. Example:  Customer List - Column A is customer nam...
Formulas and Functions
marietuttle1973's avatar
marietuttle1973
Brass Contributor
Aug 02, 2024
I'm getting an error #NAME?
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 02, 2024

marietuttle1973 

On which Excel platform/version you are?

Above is for Excel 365 or 2021

  • marietuttle1973's avatar
    marietuttle1973
    Brass Contributor
    Aug 02, 2024
    It's MS Office Home and Student 2019.
    Excel says Version 2406
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 02, 2024

      marietuttle1973 

      New Excel functions are not available in Excel 2019. In your case in A2 it could be

      =IFNA( INDEX('Customer List'!$B$2:$B$17, MATCH(Sheet1!$B2,'Customer List'!$A$2:$A$17, 0) ), "---" )

      and drag it down.

      • marietuttle1973's avatar
        marietuttle1973
        Brass Contributor
        Aug 02, 2024
        So, it populated the first part of the PO from the Customer list, but didn't assign any numbers after it.