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

Report
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!