Wannan dabara ce mai sauƙi amma mai ban sha'awa wacce ke ba ku damar canza bayanai daga ƙananan tebur ba tare da amfani da sel kwata-kwata ba. Mahimmancinsa shine zaku iya "dinka" tsararrun dabi'un maye gurbin kai tsaye cikin dabarar. Bari mu dubi hanyoyi da yawa don yin wannan.
SELECT aikin
Idan kuna buƙatar musanya bayanai daga tsararru mai girma ɗaya ta lamba, to zaku iya amfani da aikin INDEX ko mafi sauƙi kuma mafi dacewa, a cikin wannan yanayin, analog - aikin. Sakamakon (zabi). Yana fitar da sigar tsararru ta lambar sa na yau da kullun. Don haka, alal misali, idan muna buƙatar nuna sunan ranar mako ta lambarta, to za mu iya amfani da wannan ginin.
Wannan misali ne mai sauƙi da za a fara da shi don samun ra'ayin cewa za'a iya haɗa tebur na bincike kai tsaye cikin dabara. Yanzu bari mu dubi wani mafi rikitarwa, amma mafi kyawun misali.
Tsari na akai-akai a cikin dabara
A ce muna da jerin birane, inda ake amfani da aikin VPR (KYAUTA) an canza ma'auni na ƙididdigar albashi daga shafi na biyu na teburin rawaya a hannun dama:
Dabarar ita ce za ku iya maye gurbin magana zuwa kewayo tare da tebur $ E$3:$F$5 tsararru na akai-akai kai tsaye a cikin dabarar, kuma ba za a ƙara buƙatar teburin da ya dace ba. Don kada ku shigar da bayanai da hannu, kuna iya zuwa don ɗan dabaru.
Zaɓi kowane tantanin halitta mara komai. Shigar da alamar daidai daga madannai kuma zaɓi kewayon tare da tebur - ya kamata a nuna adireshinsa a cikin mashaya dabara:
Zaɓi tare da linzamin kwamfuta hanyar haɗin E3:F5 a cikin mashaya dabara kuma danna maɓallin F9 - hanyar haɗin za ta juya zuwa tsararru na akai-akai:
Ya rage don kwafi sakamakon da aka samu sannan a liƙa shi a cikin tsarin mu tare da VLOOKUP, kuma a share teburin da kansa kamar yadda ba dole ba:
Mai suna tsararru na akai-akai
Haɓaka ra'ayin hanyar da ta gabata, zaku iya gwada wani zaɓi - don yin mai suna tsararru na akai-akai a cikin RAM, wanda aka yi amfani da shi a cikin tsari. Don yin wannan, danna kan shafin tsari (Formula) button Mai sarrafa suna (Mai sarrafa sunan)… Sannan danna maballin Create, Yi tunani kuma shigar da suna (bari ya kasance, misali, Cities) da kuma a fagen range (Magana) manna jeri na akai-akai da aka kwafi a hanyar da ta gabata:
latsa OK kuma kusa Mai sarrafa suna. Yanzu ana iya amfani da sunan da aka ƙara a cikin kowane takarda na littafin a cikin kowace dabara - alal misali, a cikin aikin mu na VLOOKUP:
Karami, kyakkyawa kuma, a wata ma'ana, har ma yana kariya daga hannun wasa na ƙwararru 🙂
- Yadda ake amfani da aikin VLOOKUP don bincika bayanai daga wannan tebur zuwa wancan
- Yadda ake amfani da bincike mai ƙima tare da aikin VLOOKUP
- Lissafi ba tare da dabara ba