N

#### Neil Holden

=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

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

N

=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

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

<doesn't seem to be working?>

How do you notice?

What are your input values? Is the table sorted?

How do you notice?

What are your input values? Is the table sorted?

J

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

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:

=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

accending order.

Its not finding the value from the external worksheet.

=LOOKUP($G$14,'\\sguk-app1\Business Objects\SEUK Applications\[SEUK

Applications.xls]MTHLY SHEET'!$B:$B,'\\sguk-app1\Business Objects\SEUK

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:

=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

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

=Index('\\sguk-app1\Business Objects\SEUK Applications\[SEUK

Applications.xls]MTHLY SHEET'!$H$1:$H$1000,G14,'\\sguk-app1\Business

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

Neil Holden said:

accending order.

Its not finding the value from the external worksheet.

=LOOKUP($G$14,'\\sguk-app1\Business Objects\SEUK Applications\[SEUK

Applications.xls]MTHLY SHEET'!$B:$B,'\\sguk-app1\Business Objects\SEUK

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:

=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

**Want to reply to this thread or ask your own question?**

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.