Umsebenzi we-Excel INDIRECT

01 ngo 01

Ukufumana iDatha ngeSebenzi ye-INDIRECT

Umsebenzi we-INDIRECT, njengoko igama layo libonisa, ungasetyenziselwa ukubhekisa ngokungathanga ngqo iseli kwifom yephepha lokusebenzela .

Oku kwenziwa ngokufaka iselferensi yeseli kwiseli efundwa ngumsebenzi.

Njengokuba kuboniswe kumzekelo ongentla, umsebenzi we-INDIRECT kwiself D2 uphela ekuboniseni idatha ekhoyo kwiseli B2 - inombolo 27 - nangona ingaququzeleli ngqo kwilo lisele.

Oku kwenzeka ntoni, ngendlela ephosakeleyo, yile:

1. Umsebenzi we-INDIRECT ufumaneka kwiseli D2;
2. isalathisi eselunxwemeni esichazela umsebenzi ukufunda iziqulatho zeeseli ze-A2 - eziqulethe enye inkalo yeselfowuni - B2;
3. umsebenti ufunda oko okubhalwe kwiseli B2 - apho ufumana inombolo 27;
4. umsebenzi ubonisa le nombolo kwiseli D2.

I-INDIRECT idla ngokudibene neminye imisebenzi, njenge- OFFSET kunye ne- SUM- row 7 yomzekelo ongentla, ukudala amafomula anzima.

Ukuze le nto isebenze, umsebenzi wesibini kufuneka wamkele iselferensi yeseli njengengxabano.

Usetyenziso oluqhelekileyo lwe-INDIRECT kukuvumela ukuba utshintshe enye okanye iinkcukacha ezininzi zefomula kwifomu ngaphandle kokuba uhlele ifom ngokwayo.

Umsebenzi we-INDIRECT weSintax kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano.

I-syntax yomsebenzi we-INDIRECT ngu:

= INDIRECT (Ref_text, A1)

I-Ref_text - (efunekayo) I-reference yeselungileyo (ingaba ngu-A1 okanye i-R1C1 yesimboli yesimboli) okanye udidi olukhethiweyo olumgca 6 kumfanekiso ongentla apho iseli A6 linikwe igama elithi Alpha;

I-A1 - (okukhethwa kukho) Ixabiso elifanelekileyo (INYANISO okanye I-FALSE kuphela) ecacisa ukuba yeyiphi indlela yesalathisi yeselululwazi equlethwe kwi-Ref_text argument.

• Ukuba i-A1 iyinyaniso okanye ingashiywanga, i-Ref_text ityhilwa ngumsebenzi njengokuba isetyenziselwa i-cell ye-A1-style reference reference-row 3 yomzekelo ongentla;
• Ukuba i-A1 i-FALSE, i-Ref_text ityhilwa ngumsebenzi njengokuba isetyenzisi se-cell style ye-R1C1 engaphantsi.

#REF! Iimpazamo kunye ne-INDIRECT

INDIRECT iya kubuya i- #REF! Ixabiso lephutha xa umququzeleli we- ref_text yomsebenzi :

• asikho isalathisi eselungileyo yesellu - umqolo 8 ngentla;
• iqulethe inkcazo yangaphandle kwincwadi yokusebenzela eyahlukileyo kwaye leyo ncwadi yokusebenzela ayivuli;
• ibhekisela kwibala leseli ngaphandle kwephepha lokusebenzela - ngaphaya komqolo we-1,048,576 okanye ikholomu ye-XFD.

Ukufaka umsebenzi we-INDIRECT

Nangona kunokwenzeka ukuba uthayiphe yonke ifomula efana nayo

= INDIRECT (A2)

ngesandla kwiselfowuni yomsebenzi, enye inxaxheba kukusebenzisa ibhokisi yencoko yencoko yomsebenzi ukufaka umsebenzi kunye neziphakamiso zayo njengoko zichazwe kumanyathelo angezantsi kwiseli D2.

1. Cofa kwiseli D2 ukuze wenze iseli esebenzayo;
2. Cofa kwiThebhu yefomula yemenyu yebhondi ;
3. Khetha uLookup kunye neKhonkco kwi-Ribbon ukuvula uluhlu lwehla lokuhla;
4. Cofa kwi- INDIRECT kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi
5. Kwibhokisi yencoko, nqakraza kwi- Ref_text line;
6. Cofa kwiseli A2 kwiphepha lokusebenzela ukuze ufake ifowuni yesibini kwibhokisi yencoko njengeReg_text argument;
7. Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko;
8. Inombolo 27 ibonakala kwiseli D2 kuba yinkcukacha ekhoyo kwiseli B2
9. Xa ucofa kwiseli D2 umsebenzi opheleleyo = INDIRECT (A2) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.