lookup

[Guest]

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
__

 

[T. Valko]

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

Which sheet is the value to return on?

Biff

 

[Guest]

It is a text value

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

Which sheet is the value to return on?

Biff

 

[T. Valko]

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)*(Sheet2!C1:C10=C1),0))

Biff