Satisfying 2 conditions using if function or other function

[aparunkumar]

I have in cell a1 some data and a2 other data . In a3 there may be data or blank. I should get result in cell a4 that if a1 and a2 are equal and a3 have data, then the sama data ina3 to be get in cell a4 and if a3 has no data, then a4 also should be blank(""). Which formula or function can be used in excel 2007?

[elayaz]

See if this works.

Please Login or Register  to view this content.

[Rambo4711]

Nice elayez!
Hope that "aparunkumar" find your formula whats needed.

[aparunkumar]

Thanks Sir, This Works and Solved My Problem..