# Lokkup Issue

#### skully43

##### New Member
As mentioned previously I am attempting to put together a spreadsheet to automate the process of scoring in a football prediction competition I am running. I am no Excel expert so forgive my ignorance. My first task as I see it is to enter in a league table and then perform a lookup on this table to see where team Acctually are compared to where people predicted they would finish.

I have columm A in my spreadsheet which lists the current positions of each team that is listed i columm B so the first forumal I have used is thus
=LOOKUP("Arsenal",B3:B22,A3:A22) if Arsenal were in position 2 I would expect this to return the number that is in the position collum in this case Arsenal is in cell B4 and A4 contains the number 2 it does. However above that I have Chelsea in collum B2 and the number 1 in A2 but still the forumla returns the number 2 can someone explain where I am going wrong?

thanks

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
The value you are looking up, must be in the first column of your array

A little confused so If you lookup Arsenal, you want 2 or 1? Isn't still supposed to return 2:

Replies
2
Views
325
Replies
2
Views
593
Replies
19
Views
1K
Replies
17
Views
455
Replies
4
Views
600

1,219,978
Messages
6,151,243
Members
451,019
Latest member
cichli_04

### 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