intangiblemedia

asked on

# Matching Excel Columns on two different sheets

Hi everyone,

I need to be able to match data from one sheet to another. Let me explain.

Sheet 1

A B

Value-a Value-b

Sheet 2

A B

Value-b Value-c

So what I need it do, is see if Value-b on Sheet 2 exists, and then if it does, Sheet1 C, create value-c - if it doesnt exist, leave it empty.

The value's will not match up row by row, so the function would need to look at every value in the column independent of the sort order (hope that makes sense).

It would really help me if you could assist me on this,

Many thanks,

Ben

I need to be able to match data from one sheet to another. Let me explain.

Sheet 1

A B

Value-a Value-b

Sheet 2

A B

Value-b Value-c

So what I need it do, is see if Value-b on Sheet 2 exists, and then if it does, Sheet1 C, create value-c - if it doesnt exist, leave it empty.

The value's will not match up row by row, so the function would need to look at every value in the column independent of the sort order (hope that makes sense).

It would really help me if you could assist me on this,

Many thanks,

Ben

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
ASKER