Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup formula not evaluating correctly
I have a worksheet with 4 columns with IF formulas with column headings ABC
and D, then a column with a LOOKUP formula refering to a row vector spanning A to D. The LOOKUP formula loos for a certain value on fields ABC and D, and has to return the column heading. The LOOKUP formula is evaluating correctly for fields BC and D, but for field A, it returns the heading of column D. Does someone have any advice on this? I have tried the same setup on different files, and I get the same problem. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup formula not evaluating correctly
What are your formulas, what are the values, what result did you expect and what did you get instead?
-- Kind regards, Niek Otten Microsoft MVP - Excel "sifuentes" wrote in message ... |I have a worksheet with 4 columns with IF formulas with column headings ABC | and D, then a column with a LOOKUP formula refering to a row vector spanning | A to D. The LOOKUP formula loos for a certain value on fields ABC and D, and | has to return the column heading. The LOOKUP formula is evaluating correctly | for fields BC and D, but for field A, it returns the heading of column D. | Does someone have any advice on this? I have tried the same setup on | different files, and I get the same problem. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup formula not evaluating correctly
I think it would be easier to explain if I could post the file. Is there a
way to do that? I am new to this forum, and still finding my way arround. Thanks, Carlos Sifuentes "Niek Otten" wrote: What are your formulas, what are the values, what result did you expect and what did you get instead? -- Kind regards, Niek Otten Microsoft MVP - Excel "sifuentes" wrote in message ... |I have a worksheet with 4 columns with IF formulas with column headings ABC | and D, then a column with a LOOKUP formula refering to a row vector spanning | A to D. The LOOKUP formula loos for a certain value on fields ABC and D, and | has to return the column heading. The LOOKUP formula is evaluating correctly | for fields BC and D, but for field A, it returns the heading of column D. | Does someone have any advice on this? I have tried the same setup on | different files, and I get the same problem. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup formula not evaluating correctly
Are your LOOKUP parameters in ascending order? If not, you will get the wrong
results. "sifuentes" wrote: I think it would be easier to explain if I could post the file. Is there a way to do that? I am new to this forum, and still finding my way arround. Thanks, Carlos Sifuentes "Niek Otten" wrote: What are your formulas, what are the values, what result did you expect and what did you get instead? -- Kind regards, Niek Otten Microsoft MVP - Excel "sifuentes" wrote in message ... |I have a worksheet with 4 columns with IF formulas with column headings ABC | and D, then a column with a LOOKUP formula refering to a row vector spanning | A to D. The LOOKUP formula loos for a certain value on fields ABC and D, and | has to return the column heading. The LOOKUP formula is evaluating correctly | for fields BC and D, but for field A, it returns the heading of column D. | Does someone have any advice on this? I have tried the same setup on | different files, and I get the same problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Evaluating a range | Excel Discussion (Misc queries) | |||
Evaluating Rank to determine formula | Excel Worksheet Functions | |||
Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions | |||
If formula evaluating 2 cells contents | Excel Worksheet Functions | |||
Lookup function still not working correctly | Excel Worksheet Functions |