match in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I match 2 columns ?

a1 b1 a2 b2
c 2 d2
001 un801 lala un801
002 un802 kaka un802

My question is how can I match culomn b1 with b2, so that the information in
column a1 is copied to c2 or d2?

Thanks
 
Bart
Try that again. What constitutes "match"? What condition precipitates
the copying of data? What conditions or situations result in the
differentiation between Column C & D? HTH Otto
 
I already got the answer by the use of the formula VLOOKUP.

Sorry for the poor formulation of my question.
 

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

Copying formulas across columns 2
EXCEL ARRAYS & IF STATEMENTS 1
Work Hours 1
Turning rows of equal number of columns into 1 continuous row 1
I have a column of numbers, some negative, some positive 3
Excluding Repeating Numbers Help!1 5
FINDING AN EXACT MATCH ON 2 DIFFERENT SHEETS THEN EXECUTING A FORM 3
Copy Data from One Spreadsheet to Another ?????? 5

Back
Top