I need to compare values in columns B & C of the same row on one sheet and
find a value match in a 2 column range of another sheet and return the value
of column E of the same row from one sheet to another

SHEET 1 SHEET 2
eg B C D E B C D
E
xy yz __ xy yz
__

Is the value to return a text value or a numeric value?

Which sheet is the value to return on?

Biff

"Larry" wrote in message
...
I need to compare values in columns B & C of the same row on one sheet and
find a value match in a 2 column range of another sheet and return the
value
of column E of the same row from one sheet to another

SHEET 1 SHEET 2
eg B C D E B C
D
E
xy yz __ xy yz
__

It is a text value

"T. Valko" wrote:

Is the value to return a text value or a numeric value?

Which sheet is the value to return on?

Biff

"Larry" wrote in message
...
I need to compare values in columns B & C of the same row on one sheet and
find a value match in a 2 column range of another sheet and return the
value
of column E of the same row from one sheet to another

SHEET 1 SHEET 2
eg B C D E B C
D
E
xy yz __ xy yz
__

Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(Sheet2!E1:E10,MATCH(1,(Sheet2!B1:B10=B1)*(S heet2!C1:C10=C1),0))

Biff

"Larry" wrote in message
...
It is a text value

"T. Valko" wrote:

Is the value to return a text value or a numeric value?

Which sheet is the value to return on?

Biff

"Larry" wrote in message
...
I need to compare values in columns B & C of the same row on one sheet
and
find a value match in a 2 column range of another sheet and return the
value
of column E of the same row from one sheet to another

SHEET 1
SHEET 2
eg B C D E B C
D
E
xy yz __ xy yz
__