| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking up a value in column to return corresponding text on value
Hi,
I'm trying to find a value in column D. The value is 0.000. within 1000 rows I need the corresponding text in column B & C to appear on a different worksheet wherever this value appears. Any ideas? I've no hair left to pull out! I've been trying a few variations of vlookup but can't get it right Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Looking up a value in column to return corresponding text on value
Maybe...
=index('sheet99'!c:c,match(0,'sheet99'!d:d,0)) =index('sheet99'!e:e,match(0,'sheet99'!d:d,0)) Change sheet99 to the name of the sheet that contains the values. Lexx Wingspan wrote: Hi, I'm trying to find a value in column D. The value is 0.000. within 1000 rows I need the corresponding text in column B & C to appear on a different worksheet wherever this value appears. Any ideas? I've no hair left to pull out! I've been trying a few variations of vlookup but can't get it right Thanks in advance -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return text value found most frequently in a column | Excel Worksheet Functions | |||
| How to return the last non-blank cell in a column that is TEXT | Excel Worksheet Functions | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| Return column number from column header text | Excel Discussion (Misc queries) | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Linear Mode
