Hi Group,

I created a chart & have "NA()" in function so the chart's line don't drop to 0s.


In 1 column, I have a series of numbers. Is it possible to do a Look Up / Equal to type of function, such as:

Cell K29 has $34,260 to the last cell K32, which has value of $170,830.

I would like a Look Up Last If type of condition in which if it finds the last value in Column K, then Column L cell would equal the same value.

I attempted to use this, =IF(LOOKUP(E10+99+307,$K$29:$K$35)=K30,"") but it's not working for me.

I'm not sure if it is becaue of the "#N/A" results that gets when using the "NA()" within function.

Thanks