I'm exporting data from Access with Invoice info to import into an accounting program. I need to find the account number based on data within different fields of the exported access invoice data to determine what the Account Number is.
I have the following function, which works when i paste it in a my cell M2 and drag the formula down, but i can't see how to get this working within a macro; I've tried using it on the V column using the range finder:
Target, Me.Range("V2:V" & Range("A" & Rows.Count).End(xlUp).Row
The Macro seems to stop at "MF"
The function i have is:
=IF(ISNUMBER(FIND("MF",I2)),410,
IF(ISNUMBER(FIND("Supply",L2)),470,
IF(ISNUMBER(FIND("Primary",A2)),430,
IF(ISNUMBER(FIND("Junior",A2)),430
IF(ISNUMBER(FIND("College",A2)),420,
IF(ISNUMBER(FIND("Senior",A2)),420,
IF(ISNUMBER(FIND("Secondary",A2)),420,430)))))))
Bookmarks