# N/A error VLOOKUP

#### wayne0881

##### Board Regular
Hi All,

I am trying to get a VLOOKUP to work but for some reason its not working.

If anyone can help I would really appreciate it.

here is a smaller version of what I am trying to do:

Cells B2 B3 B4 have the numbers 1,2,3 indicating a league table position
Cells C2 C3 C4 have team names in them
Cells F2 G2 H2 I2 have Home Team, League Position, Away team, League Position

My VLOOKUP in cell G2 is =VLOOKUP(F2,B2:C4,2,0) trying to get the league pos to show up, but it returns a N/A

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### bbott

##### Well-known Member
does the value in F2 exactly match one of the cell values in B2, B3, or B4 (i.e. is F2= 1, 2, or 3)?

#### wayne0881

##### Board Regular
does the value in F2 exactly match one of the cell values in B2, B3, or B4 (i.e. is F2= 1, 2, or 3)?

Yes it does - I even copied and pasted it in so it exactly matches...

Replies
25
Views
2K
Replies
8
Views
242
Replies
26
Views
786
Replies
0
Views
302
Replies
7
Views
1K

1,191,075
Messages
5,984,490
Members
439,892
Latest member
yeevy

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back