Need to return a value based on two different search criteria, multiple lines, VLOOKUP

Hi All,

I have a report that I run at work that doesn't come out in a way that makes it easy to work with in an excel spread sheet. The best i can get it is a txt file that when pasted spreads values into different cells. I use VLOOKUP in other sheets to find one value and return another value in the same row. I don't know how to (or if it's even possible) to do this with multiple values on different rows.

Could really use some help.

I need some sort of VLOOKUP/XLOOKUP type of formula that does the following:

-Searches Column A for a specific value

-Then Searches Column B (Below where Column A value was found) for another value

-Returns the value in Column C (Same Row as B) based on the value from B

I'm pretty much stuck using Excel for this as my company doesn't allow outside/other programs to further organize the data.

Macros may also be an option if anyone knows any.

Thanks in advance with any answers.