Hello all, i need some help with an excel file. The columns and content of the file is as follows:
SRnumber Status Substatus SR_Type BranchNAme BranchNumber
123 Closed NotReached Lead JohnSmith 110
234 InProgress NotInterested Lead NULL NULL
345 Open Lead MarkEdwards 155
I need to depict the performance of the sales offices to some charts i have incorporated in the excel file. The problem is that some registries come blank at the sales offices fields. I have at a different excel sheet a table with all SR numbers and respective branch names/numbers. Thus, if the branch number is NULL i can refer to this extra sheet and retrieve the branch name and number.
In short, i need a flowchart that will check if there are NULL values at column BranchName. If yes, i need to vlookup the values of column SRnumber with the respective SRnumbers stored at the additional sheet and get the branch name and paste it at the NULL value.
Could anyone help? I am attaching part of the excel file for your convenience.
Any help would be very much appreciated.
SampleExcel.xlsx (85.0 KB)