| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up and return text values
Hi,
I have two tabs in workbook Tab "Blank" which contains a table with two columns "A" & "B" and rows "42:69." In column A you place an "x" to signify the text in column B is to be used. At the top of the table I have a row that does Autofilter lookups. Insufficient. In Tab B there is a lookup cell which contains a formula =VLOOKUP("x",Blank!A42:B69,2,0) This works well to get well to get the first row with an "x" and the text to the right. =VLOOKUP("x",Blank!A42:B69,2) This gets me the last row with an "x" and the text to the right. What I'd like to do is get the text to the right in all rows that contain an "x". So out of twenty-seven rows if three rows contain an "x" in column "A" then the return would be the text in cell B row#? + B row#?? + Brow#???. That lookup cell is one that is used with mailmerge. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count text values and return most common occurence | Excel Discussion (Misc queries) | |||
| Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions | |||
Threaded Mode
