| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
| i HAVE A PROBLEM | Excel Discussion (Misc queries) | |||
| IRM problem | Setting up and Configuration of Excel | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
