| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Corresponding Value Based on Comparing Two Sheets of Data
Can someone please help me find a formula (or two) for this example. If you
can show me a couple of ways to do this (so I can learn), I'd greatly appreciate it! Thanks! I'm trying to figure out a formula (or two) that will help me auto-populate the ? fields within ColumnB of Sheet 2. Also, I want the ? value for the "8888" row to return blank, since it does not exist in Sheet 1. Sheet 1: ColumnA ColumnB 1234 20 4321 10 5678 11 8765 - 9999 12 7777 13 Sheet 2: ColumnA ColumnB 5678 ? 8765 ? 1234 ? 4321 ? 8888 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Data on 2 sheets | Excel Discussion (Misc queries) | |||
| Comparing two lists and return specified data | Excel Worksheet Functions | |||
| return array result in cell based on comparing dates | Excel Worksheet Functions | |||
| Comparing Data between two sheets | Excel Worksheet Functions | |||
| Comparing sheets data | Excel Discussion (Misc queries) | |||
Threaded Mode
