Lookup does not return correct value

**AnnaBX** · 07-29-2014, 10:27 AM

Hi,

I have tried lots of different methods, but I just can't get this to work. I have a table with purchases allocated to dates, including "$0.00" for no purchases (see image):

lookup.jpg

I used =LOOKUP(1000,B4:I4,B2:I2) , hoping that the "1000" would result in the formula looking for a value greater than zero. Using >0 also did not work.

What I want to do is retrieve the date of the latest purchase for this line and more lines to follow. So in this case it SHOULD return 23/02/2014... Please can you help me??

**Jonmo1** · 07-29-2014, 10:32 AM

Try

=LOOKUP(2,1/(B4:I4>0),B2:I2)

**AnnaBX** · 07-29-2014, 10:36 AM

Now it returns "#N/A"

**hoyasaxa215** · 07-29-2014, 10:48 AM

A quick and unsophisticated solution would be to add a helper row that returns, for example, "Yes" if the value in Row 4 is greater than 0. Than you could use the "=DMAX" function to identify the latest date with a "Yes" in your helper row.

**AnnaBX** · 07-29-2014, 10:48 AM

You were right, I did not see the brackets, that was my mistake! Thank you!

**Jonmo1** · 07-29-2014, 10:48 AM

You're welcome.

Lookup does not return correct value

LinkBack

Thread Tools

Rate This Thread

Display

Lookup does not return correct value

Re: Lookup does not return correct value

Re: Lookup does not return correct value

Re: Lookup does not return correct value

Re: Lookup does not return correct value

Re: Lookup does not return correct value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] The formula is correct but one cell does not return correct value

LOOKUP does not always give the correct result - correct number of vectors etc checked

Formula does not return the correct value

lookup 2 columns that are data validated wont return correct info

Not Able to Get LOOKUP to Return Correct Data

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions