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