Compare Data on Two Spreadsheets to Put Input Into One Cell
 

I have two spreadsheets.

The first sheet contains 1000 entries in column A and column B. Column A
reads "ABC". Column B reads "All Brands Commercial" in row 1. In row two it
might say "ABD" in column A and "All Brands Drury" in column B.

The second sreadsheet has 26,000 entries in column A. The entries are the
same as the entries in column A on the other sheet. Example: Column A reads,
"ABC".

What I need to do is make column B on spreadsheet #2 populate with the
correct entry from Column B on the first spreadsheet.

Example: On Spreadsheet #2 row 386 in column A reads, "ABC". On Spreadsheet
#1, Column A (row 1) reads "ABC". Column B (row 1) reads, "All Brands
Commercial". I now need Spreadsheet #2, column B (row 386) to read, "All
Brands Commercial".

Can anyone help? Thanks!!!

Compare Data on Two Spreadsheets to Put Input Into One Cell
 

=VLOOKUP(A1,Sheet1!$A$1:$B$1000,2,0)


"Rob" wrote:

I have two spreadsheets.

The first sheet contains 1000 entries in column A and column B. Column A
reads "ABC". Column B reads "All Brands Commercial" in row 1. In row two it
might say "ABD" in column A and "All Brands Drury" in column B.

The second sreadsheet has 26,000 entries in column A. The entries are the
same as the entries in column A on the other sheet. Example: Column A reads,
"ABC".

What I need to do is make column B on spreadsheet #2 populate with the
correct entry from Column B on the first spreadsheet.

Example: On Spreadsheet #2 row 386 in column A reads, "ABC". On Spreadsheet
#1, Column A (row 1) reads "ABC". Column B (row 1) reads, "All Brands
Commercial". I now need Spreadsheet #2, column B (row 386) to read, "All
Brands Commercial".

Can anyone help? Thanks!!!

Compare Data on Two Spreadsheets to Put Input Into One Cell
 

Teethless mama - You are the best! Thanks!!!!!

"Teethless mama" wrote:

=VLOOKUP(A1,Sheet1!$A$1:$B$1000,2,0)


"Rob" wrote:

I have two spreadsheets.

The first sheet contains 1000 entries in column A and column B. Column A
reads "ABC". Column B reads "All Brands Commercial" in row 1. In row two it
might say "ABD" in column A and "All Brands Drury" in column B.

The second sreadsheet has 26,000 entries in column A. The entries are the
same as the entries in column A on the other sheet. Example: Column A reads,
"ABC".

What I need to do is make column B on spreadsheet #2 populate with the
correct entry from Column B on the first spreadsheet.

Example: On Spreadsheet #2 row 386 in column A reads, "ABC". On Spreadsheet
#1, Column A (row 1) reads "ABC". Column B (row 1) reads, "All Brands
Commercial". I now need Spreadsheet #2, column B (row 386) to read, "All
Brands Commercial".

Can anyone help? Thanks!!!