Another possibility:
=INDEX(Sheet1!F1:F1500, MATCH(ValueA&" "&ValueB, Sheet1!C1:C1500&"
"&Sheet1!D1:D1500, 0))
commited with Cntrl+Shift+Enter
"Monish" wrote:
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!