IF 3 conditions & results

[copyboy007]

A B C D E F

12345 _____ 11111 aaaaa 55555 zzzzz
67890 _____ 22222 bbbbb 66666 yyyyy
11111 _____ 33333 cccccc 12345 xxxxx
22222 _____ 44444 ddddd 77777 wwwww

In an inserted column, I'm attempting to display the cell address of the text entry that is next to the matching number.

Two formulas work, separately, but not together to be the same cell that can be copied -- neither when nesting the IF statements nor using OR.

=IF(MATCH(a1,c1:c4,1),ADDRESS(MATCH(a1,c1:c4,0),COLUMN(c1:c4)+1))
=IF(MATCH(a1,e1:e4,1),ADDRESS(MATCH(a1,e1:e4,0),COLUMN(e1:e4)+1))
Also, if a number in column A is in neither of columns C or E, then I'd want the result to be a blank

Any advice on how to put these three conditions for two pairs of columns work in the same formula?

 

[wideboydixon]

Book1
	A	B	C	D	E	F
1	12345	$F$3	11111	aaaaa	55555	zzzzz
2	67890		22222	bbbbb	66666	yyyyy
3	11111	$D$1	33333	ccccc	12345	xxxxx
4	22222	$D$2	44444	ddddd	77777	wwwww
Sheet1

Cell Formulas
Range	Formula
B1	=IFERROR(CELL("address",INDEX($D$1:$D$4,MATCH($A1,$C$1:$C$4,0))),IFERROR(CELL("address",INDEX($F$1:$F$4,MATCH($A1,$E$1:$E$4,0))),""))

WBD

 

[copyboy007]

It worked perfectly. This kept me up for hours. Thank you so much.