| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple criteria statement
I have Sheet 1 with 1500 rows and 20 columns
On Sheet 2 I am trying to create a report where one row/cell returns: Value in Column F from Sheet 1, but ONLY WHEN Column C in Sheet 1 = Value A, AND Column D in Sheet 2 = Value B There will only be one row (among 1500) which meets both criteria, but I cant think of how to call it and get another cell in that row to be returned. I cant use a macro / VB because my client has an older version of Excel and it will not take. Appreciate any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement, multiple criteria | Excel Worksheet Functions | |||
| If statement with multiple criteria and multiple results | Excel Discussion (Misc queries) | |||
| Multiple criteria if statement | Excel Discussion (Misc queries) | |||
| Multiple if criteria in one statement (if/sumproduct) | Excel Discussion (Misc queries) | |||
| IF statement using multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
