VLookup?????

[Hazy]

=IF(ISNA(VLOOKUP(B2,'TableB'!$Y$2:$Y$100,1,FALSE)), "",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)

 

[Ardus Petus]

=IF(ISNA(MATCH(B2,Tableb!$Y$2:$Y$100,0)),
"",INDEX(Tableb!$Y$2:$Y$100,MATCH(B2,Tableb!$Y$2:$Y$100,0)))
will return value in column A

If there are several occurences, use Data>Filter>AutoFilter or Advanced
Filter

HTH

 

[Bob Phillips]

=IF(ISNA(MATCH(B2,TableB!$B$2:$B$100,0)),"",INDEX(TableB!$A$2:$A$100,MATCH(B
2,TableB!$B$2:$B$100,0)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)