Excel – if / vlookup question

 

I have two sheets in excel, firstly I am wanting to find out which names are not in sheet 1 but are included in sheet two. Sheet 1 will eventually be the master sheet.

 

 

 

Then if there is no owner in sheet 1, I want to assign the owner from sheet two. Please can someone explain how this is done? I have given a similar example of my document below. Sheet 1 contains around 460 rows, sheet 2 contains around 580.

 

 

 

Sheet 1

 

 

A

B

C

1

ID

Name

Owner

2

00012

Apple

 

3

00013

Orange

 

4

00016

Banana

 

 

 

 

Sheet 2

 

 

A

B

C

1

ID

Name

Owner

2

00011

Grape

Paul

3

00012

Apple

Simon

4

00013

Orange

Sarah

5

00015

Plum

James

6

00016

Banana

Alex

 

By: Jess

9 thoughts on “Excel – if / vlookup question

  1. ig

    Today, while I was at work, my cousin stole my iPad and
    tested to see if it can survive a twenty five foot drop, just so
    she can be a youtube sensation. My apple ipad is
    now destroyed and she has 83 views. I know this is totally off topic but I had to share it with someone!

  2. WaynePaymn

    I know looking at your website. Cheers! [url=http://juventusdomo.it/come-aumentare-la-massa-muscolare-glutei/]come aumentare la massa muscolare glutei[/url]

  3. Alyce

    Hi,
    I have a cell H2 which has 10 in
    In cell J2 i have 0 in
    J2 Cell can change (sometimes it will be 0 sometimes it might be 15)
    In cell k2 i need to calculate if j2 = 0 then leave blank however if j2 = more than 0 return whats in h2?
    Can somebody help me please!

Comments are closed.