VLOOKUP values

[dannyboy8]

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

 

[Mike H]

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

 

[ND Pard]

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]

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]

maybe this

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

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

Mike

 

[dannyboy8]

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

maybe this

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

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

Mike

 

[Mike H]

Nope

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