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.