Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Compare columns in two sheets and copy info across [Closed]

Report
-
Posts
1883
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 23, 2021
 -
Hello,

I have two sheets open.

Sheet 1 has two columns of data (PO number, Value)
Sheet 2 has two columns of data (PO number and supplier)

What I need is to have it compare the PO numbers in sheet 1 to those in sheet 2 and if they match, copy the vendor name over to the relevant PO line in sheet 1


Many thanks for any help

Steve

1 reply

Answer 1 / 1
Posts
1883
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 23, 2021
 139
Steve, Good afternoon.

Suppose this scenario:

Sheet1
A1:A10 --> PO number
B1:B10 --> Value
C1:C10 --> Supplier Name --> FORMULA

Sheet2
A1:A20 --> PO number
B1:B20 --> Supplier Name

Try to use:

Sheet1
C1 --> =VLOOKUP(A1, Sheet2!$A$1:$B$20, 2, FALSE)

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!