Vlookup to match Value over two Columns

[JoeRooney]

Hi,

I need to look up a value across two columns

I.e. I need the vlookup to look for value in column A acrosscolumns B & C and if the value in column A is found in either column B or Cor found in both columns return that value.

A	B	C
1	5	1
2	2	2

<tbody> </tbody>

I have been working with the below formula but I am justreceiving a #ref / #N/A error.

=VLOOKUP(O:O,MOV!AI:AJ,{20,21},FALSE)

Any help is greatly appreciated.

Thanks,

 

[AlanY]

try

Book1
	A	B	C	D	E
1	1	8	6		1
2	2	10	5
3	3	5	3		3
4	4	7	1
5	5	7	1		5
6	6	6	3		6
7	7	5	6		7
8	8	7	3		8
9	9	8	8
10	10	1	8		10
Sheet2

Cell Formulas
Range	Formula
E1	=IFERROR(IFERROR(VLOOKUP(A1,$B$1:$B$10,1,0),VLOOKUP(A1,$C$1:$C$10,1,0)),"")

 

[gaz_chops]

Or maybe

=IF(COUNTIFS($B$1:$C$10,A1),A1,"")

 

[JoeRooney]

Thanks guys , both options work perfect : )

 

[gaz_chops]

You're welcome.

 

[AlanY]

Thanks guys , both options work perfect : )

you're welcome