Hi,
I was looking for a way to pull information from a report that exports to an Excel spreadsheet. The spreadsheet is ugly and was looking for a way to pull just the data I needed. The report has the agent’s name on row 1 column 2. The data I need for the rep is two rows down in column 3. I looked into VLOOKUP and HLOOKUP but haven’t been able to find a way to make it work. Does anyone have any ideas I could try?
Thank you
Amy
Thanks,
Amy
I was looking for a way to pull information from a report that exports to an Excel spreadsheet. The spreadsheet is ugly and was looking for a way to pull just the data I needed. The report has the agent’s name on row 1 column 2. The data I need for the rep is two rows down in column 3. I looked into VLOOKUP and HLOOKUP but haven’t been able to find a way to make it work. Does anyone have any ideas I could try?
Thank you
Amy
Thanks,
Amy