VLOOKUP values
Is there a way to write a vlookup using multiple lookup_values in 1 formula?
|
VLOOKUP values
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? |
VLOOKUP values
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? |
VLOOKUP values
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? |
VLOOKUP values
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? |
VLOOKUP values
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? |
VLOOKUP values
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? |
All times are GMT +1. The time now is 12:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com