LOOK UP PROBLEM

[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

 

[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)

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

 

[Niek Otten]

<doesn't seem to be working?>

How do you notice?

What are your input values? Is the table sorted?

 

[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))

 

[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)

<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

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

 

[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.

=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)

<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

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

 

[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

=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)

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.

=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)

<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

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