lookup the difference

[excellentexcel]

hi guys
im try to use the lookup function but not sure which one i want

the cell to look up is e1
the cells it could be in are a1:a20
the answer will be next to the answer in b1:20

thanks

[NBVC]

How about :

=Vlookup(E1,A1:B20,2,0)

or if cells A1:A20 are in ascending order...

=Lookup(E1,A1:B20)

[excellentexcel]

thanks nbvc
worked out they have to be in order if using lookup just after posted

is there any way i can now get this answer direct to web query

http://www.soccerbase.com/head2.sd?t...id=&'input sheet'!G3)

although i have done the look up im finding it hard to make the webaddress add the numbers required

[excellentexcel]

its ok
i need to cross reference this with
http://www.excelforum.com/excel-prog...ml#post2051663

consider this solved
thank you