You could use a "helper" column on Sheet1 containing the concatenated
content of columns C and D.
Then use vlookup on that column.

Tim


"Monish" wrote in message
...
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!