I have a Value, say 778
and a one list in one colmun
1300
1060
933
899
798
689
654
569
etc
Is there a formula that could return 798?
Another eg would be I have a value 934 and wanted to return 1060
Thanks in advance for any help
I have a Value, say 778
and a one list in one colmun
1300
1060
933
899
798
689
654
569
etc
Is there a formula that could return 798?
Another eg would be I have a value 934 and wanted to return 1060
Thanks in advance for any help
=INDEX(your_range,MATCH(778,your_range,-1)) => 798
=INDEX(your_range,MATCH(934,your_range,-1)) => 1060
I will like to tweek this a little to have a universal formula. Please see the attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks