D
dannyboy8
Is there a way to write a vlookup using multiple lookup_values in 1 formula?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
It can be done with Vlookup in some circumstances but more often is done
with Index match. What are you trying to do?
Mike
N
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.
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.
D
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)
2 lookup values, which are also in the same column (say column B for
arguements sake)
M
Mike H
maybe this
=SUMPRODUCT((A1:A20={"cat","Dog"})*(B1:B20))
Which finds cat or dog and sums the corresponding cells in B
Mike
=SUMPRODUCT((A1:A20={"cat","Dog"})*(B1:B20))
Which finds cat or dog and sums the corresponding cells in B
Mike
D
dannyboy8
Mike, is this a CTRL+SHIFT+ENTER formula?
Mike H said:maybe this
=SUMPRODUCT((A1:A20={"cat","Dog"})*(B1:B20))
Which finds cat or dog and sums the corresponding cells in B
Mike
M