comparing data and return more than result

  • Thread starter Thread starter victorwill
  • Start date Start date
V

victorwill

..I need help really bad. I made a default column
with a list of names(say A1:A10, these are names) and i
use a macro to import a text file with 3 columns (
D1:D6, E1:E6, F1:F6). the first columns (D1:D6) of the
imported file have some matching NAMES as the default
columns (A1:A10 but not all of the names) what i will
like to do is compare the defaulted columns names(A1:A10)
with the imported columns say(D1:D6) and return names
that match with their corresponding columns on a new
columns. So my result should produce 3 columns. the
matching names and their additional imported two cells.
This fomula =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
only works great but only return one column.
..
OK. This is default column A1:A5
NAMEs
john
pual
mary
henry
mike
And this is the imported columns D1:D3, E1:E3, F1:E3

NAMES(D1:D3) Hours(E1:E3) MINS(f1:F3)
pual 40 5
henry 25 45
john 13 15

I want the imported columns(D1:D3, E1:E3, F1:E3) to
compare to column(A1). Also arrange the result of import
columns to A1:
RESULT
NAMES(G1:G3) HOURS(H1:H3) MINS(I1:I3)
john 13 15
pual 40 5
henry 25 45

thanks in advance and have a nice hoilday
 
Back
Top