View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Monish Monish is offline
external usenet poster
 
Posts: 22
Default 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!