software

=IF(ISNA(VLOOKUP(B2,'TableB'!$Y$2:$Y$100,1,FALSE)) , quot;quot;,Column A in
tableB)This is the code i have.

I want to search tru all column B in table A. If i find an identical
value in table B i want the field in table A to show the corresponding
field in Column A in table B.

Also if there is 2 occurences of column B in table B, i want the field
in table A to show both values.
Any ideas? (if u can understand what im asking)--
Hazy
------------------------------------------------------------------------
Hazy's Profile: www.excelforum.com/member.php...oamp;userid=33654
View this thread: www.excelforum.com/showthread...hreadid=534286sorry, Hazy,

i have read it, but can't understand, what you are after...
VLOOKUP gives the 1st occurance from Table B. desrcibe the problem and maybe
find a different solution, than VLOOKUP.

thanks,
ANdras
(Hungary)

quot;Hazyquot; wrote:

gt;
gt; =IF(ISNA(VLOOKUP(B2,'TableB'!$Y$2:$Y$100,1,FALSE)) , quot;quot;,Column A in
gt; tableB)
gt;
gt;
gt; This is the code i have.
gt;
gt; I want to search tru all column B in table A. If i find an identical
gt; value in table B i want the field in table A to show the corresponding
gt; field in Column A in table B.
gt;
gt; Also if there is 2 occurences of column B in table B, i want the field
gt; in table A to show both values.
gt;
gt;
gt;
gt; Any ideas? (if u can understand what im asking)
gt;
gt;
gt; --
gt; Hazy
gt; ------------------------------------------------------------------------
gt; Hazy's Profile: www.excelforum.com/member.php...oamp;userid=33654
gt; View this thread: www.excelforum.com/showthread...hreadid=534286
gt;
gt;