| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A formula to look for a value in a blok (eg E1:J10) data
I am looking for a formula in Excel 2003 /2007 that wil search through a blok
of data (say C1: J10) for a value (could by alfa-nomeric) entered into a cel (say A5) Thus look in C1 : J10 for the value entered in A5 and return true if found or false if not. Alternatively perform "X" if true else "Y" Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| received "a=formula" instead of =formula after exporting data - wh | Excel Worksheet Functions | |||
| Formula to sum data from a data range | Excel Discussion (Misc queries) | |||
| Formula to capture historical data from data that changes daily | Excel Discussion (Misc queries) | |||
| Formula to capture historical data from data that changes daily | Excel Worksheet Functions | |||
| Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
Threaded Mode
