I need help with excel spreadsheet
there are 2 worksheets in a excel file. The first has a section with an Account number
and then a corresponding Account name.
In the second sheet in need to be able to do the following.
If the user types in the acount number in column a, then automatically populate column 2 with the
Account name from the first sheet.