software

I have a vendor name in Sheet 1, Cell A1 and a corresponding Vendor Number
in Sheet 1, cell C1. On Sheet 2, I have a Vendor name in cell A1 and
corresponding Vendor number in a cell C1 and the name I would like to use in
cell B1.

How do I get the B1 information from Sheet 2 to Sheet 1 by matching the
information on both?
Sheet 1
A1 = Accuflow
C1 = 15010427

Sheet 2
A1 = Accuflow
B1 = Accu
C1 = 15010427

There are many ways to that, but what I find easiest:

Insert a new column in Sheet2, in which you concatenate Columns A and C:

=A1amp;C1, Copy down

And in Sheet1, concatenate A1 and C1: =A1amp;C1 (let's say in cell D1)

Now you can use cell D1 in Sheet1 to do a VLOOKUP in Sheet2

--
Kind regards,

Niek Otten
quot;Felicia Pickettquot; gt; wrote in
message ...
gt;
gt; I have a vendor name in Sheet 1, Cell A1 and a corresponding Vendor Number
gt; in Sheet 1, cell C1. On Sheet 2, I have a Vendor name in cell A1 and
gt; corresponding Vendor number in a cell C1 and the name I would like to use
gt; in
gt; cell B1.
gt;
gt; How do I get the B1 information from Sheet 2 to Sheet 1 by matching the
gt; information on both?
gt; Sheet 1
gt; A1 = Accuflow
gt; C1 = 15010427
gt;
gt; Sheet 2
gt; A1 = Accuflow
gt; B1 = Accu
gt; C1 = 15010427
Thank you! This is exactly what I needed.

quot;Niek Ottenquot; wrote:

gt; There are many ways to that, but what I find easiest:
gt;
gt; Insert a new column in Sheet2, in which you concatenate Columns A and C:
gt;
gt; =A1amp;C1, Copy down
gt;
gt; And in Sheet1, concatenate A1 and C1: =A1amp;C1 (let's say in cell D1)
gt;
gt; Now you can use cell D1 in Sheet1 to do a VLOOKUP in Sheet2
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt;
gt;
gt; quot;Felicia Pickettquot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; I have a vendor name in Sheet 1, Cell A1 and a corresponding Vendor Number
gt; gt; in Sheet 1, cell C1. On Sheet 2, I have a Vendor name in cell A1 and
gt; gt; corresponding Vendor number in a cell C1 and the name I would like to use
gt; gt; in
gt; gt; cell B1.
gt; gt;
gt; gt; How do I get the B1 information from Sheet 2 to Sheet 1 by matching the
gt; gt; information on both?
gt; gt; Sheet 1
gt; gt; A1 = Accuflow
gt; gt; C1 = 15010427
gt; gt;
gt; gt; Sheet 2
gt; gt; A1 = Accuflow
gt; gt; B1 = Accu
gt; gt; C1 = 15010427
gt;
gt;
gt;