| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function and ignore if
Hi there
I need a If statement to Extract data in a worsheet array column B IF COLUMN A IN THAT Worksheet meets a certain condition else the if statement must ignore those that does not meet the condition and loop to the next row that meets the condition. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and ignore if
Hi,
Try this =VLOOKUP(somevalue,A1:B100,2,FALSE) where somevalue is what you arelooking for in Col A. Mike "Hicks" wrote: Hi there I need a If statement to Extract data in a worsheet array column B IF COLUMN A IN THAT Worksheet meets a certain condition else the if statement must ignore those that does not meet the condition and loop to the next row that meets the condition. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore text in SUM function | Excel Discussion (Misc queries) | |||
| How to ignore text on SUM() function... | Excel Worksheet Functions | |||
| How to make average function ignore MIN and MAX | Excel Worksheet Functions | |||
| Function to ignore decimals | Excel Worksheet Functions | |||
| Ignore text Function | Excel Worksheet Functions | |||
Hybrid Mode
