You could always add another column which concatenates the values in v1 and
v2 and then use vlookup against that.

--
Tim Williams
Palo Alto, CA


"jgriffs" wrote in
message ...

Hi! Searching for "vlookup multiple criteria" yielded answers suggesting
a method other than vlookup
I'd like to accomplish the following (obviously the syntax is an
abortion).
Givens are variable(v) 1 and v2. By this time in my program, they are
defined.
Goal is to lookup a qty to call v3
Something like:
v3=vlookup((sheet2:v1,tablecolumn1)
AND(sheet2:v2,tablecolumn2)),3)
The 3 at the end would say that v3=the value in the 3rd column.
My first column has multple entries matching v1 and are not grouped
together.
The second column then has only one entry where v2 exists in
conjunction with v1. I need to assign the value in column 3 to v3.
Can a pure vlookup statement handle this?
John


--
jgriffs
------------------------------------------------------------------------
jgriffs's Profile:
http://www.excelforum.com/member.php...o&userid=30947
View this thread: http://www.excelforum.com/showthread...hreadid=508335