# Find last value in column

1. ## Find last value in column

Hello hello i need some help . i need find last value in column be some criteria

PHP Code:
``` 1    DOG           1000     2    ANT            800     3    CAT            900     4    DOG            950 5    ANT            750  ```
4 DOG 950 - corect value whitch i need

1- criteria find all values with criteria DOG
2- show last in column value (last not biggest)

i finde this tu formulas:

HTML Code:
but when i whrite i have hest error #N/A
i attach sample.

i don't whant any vba jest simple formula.

2. ## Re: Find last value in column

change this

={IF(ISNUMBER(G1);LOOKUP(9,99999999999999E+307;IF(Sheet3!\$B\$2:\$B\$6=E1;Sheet3!\$C\$2:\$C\$6));0)}

to this

={IF(ISNUMBER(G1);LOOKUP(9,99999999999999E+307;IF(Sheet3!\$B\$2:\$B\$6=D1;Sheet3!\$C\$2:\$C\$6));0)}

3. ## Re: Find last value in column

Change E1 to D1 !

4. ## Re: Find last value in column

Oh dear what a fool I. thnx Crooza

5. ## Re: Find last value in column

If I understand what you want to do, this should work.

Data Range
 A B C D E 1 ------ ------ ------ ------ ------ 2 DOG 1000 Dog 950 3 ANT 800 4 CAT 900 5 DOG 950 6 ANT 750

This formula entered in E2:

=LOOKUP(2;1/(A2:A6=D2);B2:B6)

There are currently 1 users browsing this thread. (0 members and 1 guests)