ADP Account Manager interview questions

A recruiter reached out to me telling me about two open positions. One was for BD and the other was for AM. He set up an interview with the hiring manager to determine what the best fit was for me. The first thing the hiring manager said was they didn't currently have any openings but wanted to interview for the future. While I appreciate the manager was upfront, the recruiter was not.

overall the interview was 2 hours long, and it included many situational questions. second part was technical - Excel Vlookup tasks. before interview you have to complete an analytical test