[ neleta @ 25.05.2016. 18:05 ] @
Kako da formulu vlookup povucem u 100 polja ispod a da ne unosim ponovo formula glasi ovako =VLOOKUP(D5,Sheet1!A3:C9,2,FALSE) treba samo da menja uslov D5 a ostalo sve da ostane isto? |
[ neleta @ 25.05.2016. 18:05 ] @
[ ib.kroki @ 25.05.2016. 18:48 ] @
=VLOOKUP(D5,Sheet1!$A$3:$C$9,2,FALSE)
[ neleta @ 26.05.2016. 17:18 ] @
Hvala puno, to je to!
Copyright (C) 2001-2025 by www.elitesecurity.org. All rights reserved.
|