software

Hi!

In general, there are better ways to write this formula:

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

Try one of these:

=IF(ISNA(MATCH(A1,Sheet1!A$1:A$100,0)),quot;quot;,VLOOKUP( A1,Sheet1!A$1:G$100,3,0))

=IF(COUNTIF(Sheet1!A$1:A$100,A1),VLOOKUP(A1,Sheet1 !A$1:G$100,3,0),quot;quot;)

If there are multiple instances of the lookup value use this formula entered
as an array using the key combo of CTRL,SHIFT,ENTER:

=IF(ROWS($1:1)lt;=COUNTIF(Sheet1!A$1:A$100,A$1),INDE X(Sheet1!C$1:C$100,SMALL(IF(Sheet1!A$1:A$100=A$1,R OW(A$1:A$100)-ROW(A$1) 1),ROWS($1:1))),quot;quot;)

Copy down until you bet blanks.

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

Not sure what you mean by that ???

Biff

quot;javinoquot; gt; wrote in
message ...
gt;
gt; I have something like this:
gt;
gt; =If(A1=VLOOKUP(A1,'SHEET'!A$1$100,1,FALSE),VLOOK UP(A1,'SHEET'!A$1:G$100,*3*,FALSE),quot;quot;)
gt;
gt; If the condition is true more than once, how can it return the
gt; additional corresponding values of column 3?
gt;
gt; BTW :is it redundant to use the condition and then use a FALSE range
gt; lookup?
gt;
gt;
gt; --
gt; javino
gt; ------------------------------------------------------------------------
gt; javino's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29678
gt; View this thread: www.excelforum.com/showthread...hreadid=493983
gt;

I have something like this:

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

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: www.excelforum.com/member.php...oamp;userid=29678
View this thread: www.excelforum.com/showthread...hreadid=493983
Thank you Biff! I'll check it out.--
javino
------------------------------------------------------------------------
javino's Profile: www.excelforum.com/member.php...oamp;userid=29678
View this thread: www.excelforum.com/showthread...hreadid=493983