Another look-up question

[denmarwhite]

Any advice to this problem will be greatly appreciated.

I have a 20,000 row sheet with two columns, 'Location' and 'Branch' in columns A & B. There are 10 unique entries under Location and 1,000 unique entries under Branch, so there are multiple duplications in A & B combinations. I have a table of 1,500 unique combinations of Location and Branch, along with a third column, 'Cost Center' in columns Q, R, S.

My question is that I am trying to find the value in S (Cost Center) when A & B equals an exact match for columns Q & R.

I've typically used vLookup, but with only one lookup value.

[ragulduy]

I would suggest with that many rows you probably want to have two helper columns, one which is:
=A&B
and one which is
=Q&R
then you can do a normal vlookup using the helper column values.

You can do it without helper columns but might take a while to calculate for that many.

[denmarwhite]

That is an excellent - and very workable - solution, yudlugar. Thanks!