excel - Vlookup/transpose with range -
i trying vlookup transpose ranges. these stock coverage report of mobile spare parts. whatever have covered stock buffer updated status against corresponding ranges ascending order. (how many mobile stock covered-like 1,2,10,20)
anyone appreciated.
data description modle status apricot 11 done avocado 10 done banana 8 done bilberry 7 done blackberry 16 done blackcurrant 20 done blueberry 2 done desired result area 7320 5520 5510 3320 1102 1100 950 940 930 920 919 918 917 916 915 914 913 912 911 910 blueberry done done blackcurrant done done done done done done done done done done done done done done done done done done done done blackberry done done done done done done done done done done done done done done done done bilberry done done done done done done done banana done done done done done done done done avocado done done done done done done done done done done apricot done done done done done done done done done done done
enter following formula in b13, assuming top @ a1, , fill right , bottom:
=if(count($b$12:$u$12)<vlookup($a13,$a$3:$c$9,2,false)+column(a13),"done","") assume there's better way find length of range hardcoding $b$12:$u$12.
Comments
Post a Comment