Compare Data on Two Spreadsheets to Put Input Into One Cell

G

Guest

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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing columns in two spreadsheets 1
Combine information from two pages, two changing locations. 6
export data between spreadsheets 1
return unique data from a list 4
Copy corresponding cell in Column B if cell in A contains certain text? 1
Splitting data from one spreadsheet into multiple spreadsheets 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
convert columns to rows 6

Top