How can i get the result from the next row in lookup table
example sheet attachedVlookup.xlsx
How can i get the result from the next row in lookup table
example sheet attachedVlookup.xlsx
Hello
you can use index/mathc
=INDEX($F$3:$F$8,MATCH(A14,$C$3:$C$8,TRUE)+1)
hth.
Last edited by vlady; 08-14-2012 at 01:42 AM. Reason: range error
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Your welcome.
if you come across any problem again, we are just here to lend a hand.
Cheers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks