| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup function
If B5 matches a text in columb C, show answer in cell E5 from columb D in
same row. DESCRIPTION FILE CATEGORY RESULT sandy marks (B5) "*tom sanders*" EVANGELIST ELECTRICIAN dave marks "*Mom*" HOUSE WIFE (ANSWER) marks "*DAVE*" TRAFFIC CONT. tom sanders "*sandy*" (MATCH) ELECTRICIAN (DATA NEEDED) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lookup function
It's not real clear what you're trying to do.
Can't tell what your data looks like with that sample. Try reposting your sample data but use something like commas to separate the columns from one another. -- Biff Microsoft Excel MVP "sim" wrote in message ... If B5 matches a text in columb C, show answer in cell E5 from columb D in same row. DESCRIPTION FILE CATEGORY RESULT sandy marks (B5) "*tom sanders*" EVANGELIST ELECTRICIAN dave marks "*Mom*" HOUSE WIFE (ANSWER) marks "*DAVE*" TRAFFIC CONT. tom sanders "*sandy*" (MATCH) ELECTRICIAN (DATA NEEDED) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Lookup function and Sum function | Excel Worksheet Functions | |||
| LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Linear Mode
