Hello,
I am having a problem returning a value from a different worksheet based on an entry in the previous column. Basically I need to keep an inspection log in descending order based on date. So as we do an inspection I will add a new row at the top of the sheet. My problem is when I select who did the inspection from a dropdown list I want their Certificate # entered automatically. I created a list of names and certificate numbers on a separate sheet (Data) for the dropdown lists and need to pull the certificate # from this sheet as well. I tried using the OFFSET/MATCH function (not sure if this is the best function for what I'm trying to do) but was unable to wrap my head around how to get it to work and also be dynamic as I add new rows.
I am having a problem returning a value from a different worksheet based on an entry in the previous column. Basically I need to keep an inspection log in descending order based on date. So as we do an inspection I will add a new row at the top of the sheet. My problem is when I select who did the inspection from a dropdown list I want their Certificate # entered automatically. I created a list of names and certificate numbers on a separate sheet (Data) for the dropdown lists and need to pull the certificate # from this sheet as well. I tried using the OFFSET/MATCH function (not sure if this is the best function for what I'm trying to do) but was unable to wrap my head around how to get it to work and also be dynamic as I add new rows.
