Search for a value in either of two columns.

[ChevyCorn]

Hi there,
I'm trying to search for a value in either column A or B and return the corresponding value in C. A and B values are not connected - I just want to offer two options to search. I don't think vlookup will work - any advice please?
Thanks!

 

[Peter_SSs]

Would this do what you want?

20 10 22.xlsm
	A	B	C	D	E	F
1					Search For	Result
2	Name 4	Name 16	Val 1		Name 13	Val 2
3	Name 5	Name 13	Val 2		Name 101	Not found
4	Name 6	Name 10	Val 3		Name 1	Val 5
5	Name 3	Name 11	Val 4
6	Name 1	Name 14	Val 5
7	Name 2	Name 12	Val 6
8	Name 7	Name 15	Val 7
Lookup 2 columns

Cell Formulas
Range	Formula
F2:F4	F2	=IFNA(VLOOKUP(E2,A$2:C$8,3,0),IFNA(VLOOKUP(E2,B$2:C$8,2,0),"Not found"))

 

[ChevyCorn]

That's great - thanks so much!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.