Matching values in 3 columns, same row, and returning a value in same row from 4th column

It would seem an =IF(AND(value1,value2,value3),=value_I_want,return_value,"")
might work.

EDIT: now that I reread your request, it might have to be altered, look for it in another post.

Entered as an ARRAY formula (by presing Ctrl + Shift + Enter, instead of just Enter), you could try:

Formula:

Please Login or Register  to view this content.

- Moo

ok, so Moo gave you one option, here is another...
=IF(AND('Worksheet 1'!B2='Worksheet 2'!B2,'Worksheet 1'!E2='Worksheet 2'!E2,'Worksheet 1'!F2='Worksheet 2'!F2),'Worksheet 1'!N2,"")
if I grasped your request.

EDIT: oh, and paste that into N2 on worksheet 2.