R
Robin
I have a data range called Benefits. This range does not include the header
row - that is a seperate range named BenefitHeader. The data looks something
like this:
Name Owner Terminated Var1
LTC 0 12/31/2007 TRUE
LTC 0 TRUE
SRP 1 12/31/2007 EP
SRP 0 EP
SRP 1 S162
SRP 0 S162
I need to be able to lookup based on Name and any one or two of the other
columns within the named range (Currently, the columns used are A:IE and more
could be added at any time). To do a single lookup value I would just use
=VLOOKUP("LTC",Benefits,MATCH("terminated",BenefitHeader,0))
and that would get the first instance of LTC and pull the terminated value.
However, how would I get, for example, the terminated value for SRP where
owner is 1 and Var1 is S162? I'd like to do this without concatenating
columns, if
possible, because I want to keep it flexible when determining which columns
to use. I am open to adding a UDF where I pass it the column headings for
values I want to specify and the column heading for the value that I would
like to get. I think it must be possible but I don't know how to do it.
Any help will be appreciated!!
row - that is a seperate range named BenefitHeader. The data looks something
like this:
Name Owner Terminated Var1
LTC 0 12/31/2007 TRUE
LTC 0 TRUE
SRP 1 12/31/2007 EP
SRP 0 EP
SRP 1 S162
SRP 0 S162
I need to be able to lookup based on Name and any one or two of the other
columns within the named range (Currently, the columns used are A:IE and more
could be added at any time). To do a single lookup value I would just use
=VLOOKUP("LTC",Benefits,MATCH("terminated",BenefitHeader,0))
and that would get the first instance of LTC and pull the terminated value.
However, how would I get, for example, the terminated value for SRP where
owner is 1 and Var1 is S162? I'd like to do this without concatenating
columns, if
possible, because I want to keep it flexible when determining which columns
to use. I am open to adding a UDF where I pass it the column headings for
values I want to specify and the column heading for the value that I would
like to get. I think it must be possible but I don't know how to do it.
Any help will be appreciated!!