I am setting up a sheet for who works when at the firehouse. I have 25 group numbers down column A and 25 corresponding names down column B.
On the same sheet, there is a seperate spot for what particular 7 groups work that particular day. What I need to do is when a number is put in the left column the name corresponding to that number would appear in the adjacent cell. So as not to type the whole persons name each time just his number.
All help is greatly appreciated
FF Vaccaro
On the same sheet, there is a seperate spot for what particular 7 groups work that particular day. What I need to do is when a number is put in the left column the name corresponding to that number would appear in the adjacent cell. So as not to type the whole persons name each time just his number.
All help is greatly appreciated
FF Vaccaro