| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare data between spreadsheets? | Excel Worksheet Functions | |||
| Compare data on two spreadsheets. | Excel Discussion (Misc queries) | |||
| compare data from several spreadsheets | Excel Discussion (Misc queries) | |||
| how do I compare data in Exel spreadsheets? | Excel Discussion (Misc queries) | |||
| How do I compare data in two different spreadsheets i.e. (column . | Excel Discussion (Misc queries) | |||
Hybrid Mode
