I have something like this:

=If(A1=VLOOKUP(A1,'SHEET'!A$1:D$100,1,FALSE),VLOOK UP(A1,'SHEET'!A$1:G$100,*3*,FALSE),"")

If the condition is true more than once, how can it return the
additional corresponding values of column 3?

BTW :is it redundant to use the condition and then use a FALSE range
lookup?


--
javino
------------------------------------------------------------------------
javino's Profile: http://www.excelforum.com/member.php...o&userid=29678
View this thread: http://www.excelforum.com/showthread...hreadid=493983