| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Query
Hi all,
Not sure if this is possible but I have a range of data in column B1:B200 and a range of text in column A1:A200. I want to set a formula so that if the data in any of the cells in column B equals a particular value then the text from the relevant cell in column A is output |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Query
C1 is the text to be seached in B
=INDEX(A1:B200,MATCH(C1,B1:B200,0),1) -- If this post helps click Yes --------------- Jacob Skaria "Pmcl" wrote: Hi all, Not sure if this is possible but I have a range of data in column B1:B200 and a range of text in column A1:A200. I want to set a formula so that if the data in any of the cells in column B equals a particular value then the text from the relevant cell in column A is output |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula query - please help | Excel Worksheet Functions | |||
| IF formula query - Help!! | Excel Worksheet Functions | |||
| Formula query | Excel Worksheet Functions | |||
| Formula Query | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Linear Mode
