I have Excel 2000.

I am having trouble with a lookup returning the wrong value (either
VLookup or Lookup). The first column is the output of an IF function
where desired outcome results in a specific text or number (I've tried
both) and the next column is a text value I wish output. The Lookup
value is one unique specific text or number in the first column.

The table also contains calculations based on a separate variable which
determine the result of the IF statement.

Depending on the variable, the lookup either funtions correctly or it
returns the last row's value (even when that is incorrect).

I need suggestions as to why the Lookup doesn't always work correctly.

Thanks

Motorjobs


--
motorjobs
------------------------------------------------------------------------
motorjobs's Profile: http://www.excelforum.com/member.php...o&userid=35645
View this thread: http://www.excelforum.com/showthread...hreadid=554311