| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Text based upon text matching
I have two separate worksheets
Worksheet A COLUMNA COLUMNB Insurance Company Name Maketer NAME Aetna John Smith BCBC Mary Doolittle Abbington Mike Doe Worksheet B COLUMNA COLUMNH Insurance Company Name Marketer Name Aetna BCBC Abbington I need the Marketer Name to show up in Column H of Worksheet B based upon the insurance company matching in both worksheets. I have done the following formula however it does not work...I am thinking I have to do an array...can someone help me? =VLOOKUP(A2,Sheet1!A1:B68,2,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Cells of Text and Return Highest Value based on a Customiz | Excel Discussion (Misc queries) | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| return values from an array based on matching text value | Excel Worksheet Functions | |||
| Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
Threaded Mode
