VLOOKUP, Multiple Arguments (IF, Then)

Hi I am trying to figure out if I can do TWO Lookups, probably using an if / then or something similiar to segment data.

So Spreadsheet One
Classification (e.g. Cook)
Timeframe (e.g. Q1 2022)
Metric Point (Data like results)

So I am trying to call out in my NEW spreadsheet -
IF Classification = "vlookup classification" AND equals "vlookup timeframe", then return Conversion, etc.

Is that possible?

Originally Posted by helpwithexcel1

. . . IF Classification = "vlookup classification" AND equals "vlookup timeframe", then return Conversion, etc. . . .

I'd guess you want to look up on 2 different columns, in which case you'd want something like

Formula:

Please Login or Register  to view this content.

Please realize your explanation makes sense to at most you. I'm just guessing based on a lot of experience guessing.