| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match
Hello,
I would like to ask for help with a formula. If I have data in two columns of one sheet; and on the second sheet I would like to bring over only the second column if the data in the first columns matches - what is hte formula I would use for this? Example: Sheet 1 - Column A "jim" Column B "Smith" Sheet 2 - Column A "jim" column B (formula that would pull over Smith when it matches the jim). Thanks for the help. Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Threaded Mode
