comparing data and return only data that exsist in the 2 columns

V

victorwill

1. 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:E6). 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 work if I need one column.thanks in advance
 
G

Guest

how about another if formula in the column next to the
match formula column? Assuming the match formula is in
column G, column H can be =IF(G1="","",E1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing data and return more than result 1
help needed with lookup and related functions 3
Comparing Text between Columns 6
have an entire row populate with a link when the data in a cell ch 1
VLookup Data, Find 2 Adjacent Rows, Return Value in 1 Row 3
Problem with vlookup and isna function 3
Macro for comparing columns and highlighting matching/differences 14
Two Critera to match another spreadsheet and return single criteri 2

Top