Lookup

[Pete]

I see two ways of interpreting your request, so here are
two answers.

1) I would write the following in column F:

=if(b1=d1,e1,"")

Then copy this down that new column. This puts a blank
in column F if b and d are not equal in that row, and
puts the col e value there if they are equal.

2) If you do not want to do this comparison at all
unless A and C are equal, then you'll need this:

=if(and(a1=c1,b1=d1),e1,"")

In other words you do not care to post the e1 value if B
and D are equal, unless A and C are also equal.

Your choice--hope this helps!

Regards,
Peter

 

[Pete]

I think the second if statement in my prior reply will do
the trick if you make its precondition if(and
(a1=500000,b1=d1),etc.)

Experiment with it and you should be able to learn what
gives the results you want.

Regards,
Peter