H
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)
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)