Vlookup not recognizing the second column value

[topswim]

When creating my Vlookup formula I am having issues with getting both columns in my array, but I also notice when I only want the value in the second column, it doesn't find the value. The below formula (column D) comes back with #N/A instead of C. When I change the column from 2 to 1 (=vlookup(A4,B1:C5,1,false)) it brings back the first column value, which in this case would be 3. when I enter a formula (=vlookup(A4,B1:C5,{1,2},false) I only receive back the first column value again (3) instead of 3 and C

example:

column A

column B

column C

column D

1	App	3	=vlookup(C1,B1:C5,2,false)
2	Burr
3	grey
4	yellow
5	E

 

[Fluff]

Considering all those formulae are looking for a number in col B, I would expect all of them to return #N/A

 

[topswim]

Considering all those formulae are looking for a number in col B, I would expect all of them to return #N/A

Let me try that again as I turned a couple items around when I posted the formula- =vlookup(C1,A1:B5,2,false)) or =vlookup(C1,A1:B5,{1,2},false))

 

[Fluff]

With the exception of the extra bracket at the end, that works for me

+Fluff 1.xlsm
	A	B	C	D	E
1	1	App	3	3	grey
2	2	Burr
3	3	grey
4	4	yellow
5	5	E
Lists

Cell Formulas
Range	Formula
D1:E1	D1	=VLOOKUP(C1,A1:B5,{1,2},FALSE)
Dynamic array formulas.

 

[topswim]

With the exception of the extra bracket at the end, that works for me

+Fluff 1.xlsm
	A	B	C	D	E
1	1	App	3	3	grey
2	2	Burr
3	3	grey
4	4	yellow
5	5	E
Lists

Cell Formulas
Range	Formula
D1:E1	D1	=VLOOKUP(C1,A1:B5,{1,2},FALSE)
Dynamic array formulas.

Cell Formulas
Range	Formula
Dynamic array formulas.

 

[topswim]

i ended up restarting my computer and that seemed to resolve the issue. thanks again

 

[Fluff]

Glad it's sorted & thanks for the feedback.