Vlookup 2 Criteria (non array)

[Siops]

Good day! I just want to ask if it's possible to use a formula (vlookup) using a 2 criteria without using an array (ctrl+shift+enter) method.

I am using the INDEX MATCH method however since I have thousands of rows (55k), it takes a looong time before it generate the data. Maybe if I will use a simple formula just like a vlookup, it will lessen the generation of the data.

Thank you in advance!

[TMS]

It depends on how static the target data is and if it is in a table. The simplest way would be to have a helper column and concatenate the two key/searched fields (with &). You can then concatenate the search items and do a simple VLOOKUP. The advantage of the data being in a table is that the concatenated help field will be maintained automatically.


Regards, TMS

[Siops]

Please disregard. Already found a formula using the lookup thinggy. Thank you!

[TMS]

No problem. Maybe you could share your approach for the benefit of others?


Regards, TMS

[Siops]

Hi TMS, actually what I used is the one you suggested.

LOOKUP(2,1/((A:A=x1)*(B:B=x2)),C:C)