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!