Is there a way to write a vlookup using multiple lookup_values in 1 formula?

Hi,

It can be done with Vlookup in some circumstances but more often is done
with Index match. What are you trying to do?

Mike

"dannyboy8" wrote:

Is there a way to write a vlookup using multiple lookup_values in 1 formula?

Absolutely.

Concatenate your data into one column and make sure that the resulting data
is also a cell in the left column of your look-up array (table range).

For example: IF cell B1 contains an "A" and C1 contains a "B" and D1
contains "C" and you need to lookup "ABC", then in column A1 enter the
concatenating forumla:

=B1&C1&D1

to get "ABC".

Now, assuming there is a cell with "ABC" in the left column of the lookup
range, BINGO ... your vLookUp formula will work.

Good Luck.

"dannyboy8" wrote:

Is there a way to write a vlookup using multiple lookup_values in 1 formula?

I am trying to lookup 2 values in the same column A and get the sum of these
2 lookup values, which are also in the same column (say column B for
arguements sake)

"Mike H" wrote:

Hi,

It can be done with Vlookup in some circumstances but more often is done
with Index match. What are you trying to do?

Mike

"dannyboy8" wrote:

Is there a way to write a vlookup using multiple lookup_values in 1 formula?

maybe this

=SUMPRODUCT((A1:A20={"cat","Dog"})*(B1:B20))

Which finds cat or dog and sums the corresponding cells in B

Mike

"dannyboy8" wrote:

I am trying to lookup 2 values in the same column A and get the sum of these
2 lookup values, which are also in the same column (say column B for
arguements sake)

"Mike H" wrote:

Hi,

It can be done with Vlookup in some circumstances but more often is done
with Index match. What are you trying to do?

Mike

"dannyboy8" wrote:

Is there a way to write a vlookup using multiple lookup_values in 1 formula?

Mike, is this a CTRL+SHIFT+ENTER formula?

"Mike H" wrote:

maybe this

=SUMPRODUCT((A1:A20={"cat","Dog"})*(B1:B20))

Which finds cat or dog and sums the corresponding cells in B

Mike

"dannyboy8" wrote:

I am trying to lookup 2 values in the same column A and get the sum of these
2 lookup values, which are also in the same column (say column B for
arguements sake)

"Mike H" wrote:

Hi,

It can be done with Vlookup in some circumstances but more often is done
with Index match. What are you trying to do?

Mike

"dannyboy8" wrote:

Is there a way to write a vlookup using multiple lookup_values in 1 formula?

Nope

"dannyboy8" wrote:

Mike, is this a CTRL+SHIFT+ENTER formula?

"Mike H" wrote:

maybe this

=SUMPRODUCT((A1:A20={"cat","Dog"})*(B1:B20))

Which finds cat or dog and sums the corresponding cells in B

Mike

"dannyboy8" wrote:

I am trying to lookup 2 values in the same column A and get the sum of these
2 lookup values, which are also in the same column (say column B for
arguements sake)

"Mike H" wrote:

Hi,

It can be done with Vlookup in some circumstances but more often is done
with Index match. What are you trying to do?

Mike

"dannyboy8" wrote:

Is there a way to write a vlookup using multiple lookup_values in 1 formula?