|
LOOK UP PROBLEM
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 |
LOOK UP PROBLEM
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" wrote: 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 |
LOOK UP PROBLEM
<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" wrote in message ... 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 |
LOOK UP PROBLEM
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)) -- Jacob "Neil Holden" wrote: 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 |
LOOK UP PROBLEM
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" wrote: <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" wrote in message ... 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 |
LOOK UP PROBLEM
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" wrote: <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" wrote in message ... 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 |
LOOK UP PROBLEM
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" wrote: 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" wrote: <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" wrote in message ... 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 |
| All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com