Lookup formula not evaluating correctly

[Guest]

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.

 

[Niek Otten]

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

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

 

[Guest]

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

 

[Guest]

Are your LOOKUP parameters in ascending order? If not, you will get the wrong
results.