LOOK UP PROBLEM

  • Thread starter Thread starter Neil Holden
  • Start date Start date
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
 
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:
Click to expand...

=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
Click to expand...
 
<doesn't seem to be working?>

How do you notice?

What are your input values? Is the table sorted?
 
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))
 
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
Click to expand...
Click to expand...
 
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)

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
Click to expand...
Click to expand...
 
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)

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.

=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:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top