# LOOK UP PROBLEM

N

#### Neil Holden

Hey, i am using excel 2003 and i have a lookup formula:

=LOOKUP(\$G\$14,'[SEUK Applications.xls]MTHLY SHEET'!\$B:\$B,'[SEUK
Applications.xls]MTHLY SHEET'!\$H:\$H)

This is pulling information from an external work sheet but doesn't seem to
be working?

Can anyone stop the obvious?

Thanks

E

#### Eduardo

Hi,
In excel 2003 you need to give a range to the column for example B1:B100
another think you need to specify which column

=VLOOKUP(\$G\$14,'[SEUK Applications.xls]MTHLY SHEET'!\$B1:\$H1000,7,false)

Neil Holden said:
Hey, i am using excel 2003 and i have a lookup formula:

=LOOKUP(\$G\$14,'[SEUK Applications.xls]MTHLY SHEET'!\$B1:\$H1000,7,false)
=LOOKUP(\$G\$14,'[SEUK Applications.xls]MTHLY SHEET'!\$B:\$B,'[SEUK
Applications.xls]MTHLY SHEET'!\$H:\$H)

This is pulling information from an external work sheet but doesn't seem to
be working?

Can anyone stop the obvious?

Thanks

N

#### Niek Otten

<doesn't seem to be working?>

How do you notice?

What are your input values? Is the table sorted?

J

#### Jacob Skaria

For LOOKUP() to work the data needs to be sorted. Try the below
instead...Also edit the path of the xls file in the below formula

=INDEX('C:\[SEUK Applications.xls]MTHLY SHEET'!\$H:\$H,MATCH(\$G\$14,
'C:\[SEUK Applications.xls]MTHLY SHEET'!\$B:\$B,0))

E

#### Eduardo

Hi,
with lookup your table has to be sorted if not try

=Index('[SEUK Applications.xls]MTHLY SHEET'!\$H\$1:\$H\$1000,G14,'[SEUK
Applications.xls]MTHLY SHEET'!\$B\$1:\$B\$1000)

Niek Otten said:
<doesn't seem to be working?>

How do you notice?

What are your input values? Is the table sorted?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Neil Holden said:
Hey, i am using excel 2003 and i have a lookup formula:

=LOOKUP(\$G\$14,'[SEUK Applications.xls]MTHLY SHEET'!\$B:\$B,'[SEUK
Applications.xls]MTHLY SHEET'!\$H:\$H)

This is pulling information from an external work sheet but doesn't seem
to
be working?

Can anyone stop the obvious?

Thanks

N

#### Neil Holden

Its returning a value of 0, below is the formula. The table is sorted in
accending order.

Its not finding the value from the external worksheet.

Applications\[SEUK Applications.xls]MTHLY SHEET'!\$H:\$H)

Niek Otten said:
<doesn't seem to be working?>

How do you notice?

What are your input values? Is the table sorted?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Neil Holden said:
Hey, i am using excel 2003 and i have a lookup formula:

=LOOKUP(\$G\$14,'[SEUK Applications.xls]MTHLY SHEET'!\$B:\$B,'[SEUK
Applications.xls]MTHLY SHEET'!\$H:\$H)

This is pulling information from an external work sheet but doesn't seem
to
be working?

Can anyone stop the obvious?

Thanks

E

#### Eduardo

Hi,
you are working in excel 2003 you need to have a range you cannot just to
refer to columns, for example H1:H2000

or you can try my other formula

Objects\SEUK Applications\[SEUK Applications.xls]MTHLY SHEET'!\$B\$1:\$B\$1000)

Neil Holden said:
Its returning a value of 0, below is the formula. The table is sorted in
accending order.

Its not finding the value from the external worksheet.

Applications\[SEUK Applications.xls]MTHLY SHEET'!\$H:\$H)

Niek Otten said:
<doesn't seem to be working?>

How do you notice?

What are your input values? Is the table sorted?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Neil Holden said:
Hey, i am using excel 2003 and i have a lookup formula:

=LOOKUP(\$G\$14,'[SEUK Applications.xls]MTHLY SHEET'!\$B:\$B,'[SEUK
Applications.xls]MTHLY SHEET'!\$H:\$H)

This is pulling information from an external work sheet but doesn't seem
to
be working?

Can anyone stop the obvious?

Thanks