Hi All,
I have two sheets that I am working on ='Table Of Values'! and ='Report Template'!.
In cell AE14 of the sheet ='Report Template'! I have a name of the city. I would like to match and list the related data of the column "Location Rates" that are in C9:C192 in ='Table Of Values'!. I also need the name of the Location Rates' Owner Property which is listed in A9:A192. I would like to collect the listed Location Rate and the Location Rate Owner Property values in ='Report Template'!. How can I do this? Please help.
Best regards.
I have two sheets that I am working on ='Table Of Values'! and ='Report Template'!.
In cell AE14 of the sheet ='Report Template'! I have a name of the city. I would like to match and list the related data of the column "Location Rates" that are in C9:C192 in ='Table Of Values'!. I also need the name of the Location Rates' Owner Property which is listed in A9:A192. I would like to collect the listed Location Rate and the Location Rate Owner Property values in ='Report Template'!. How can I do this? Please help.
Best regards.