Results 1 to 16 of 16
Thread: Excel.
Hybrid View
-
20th July 2010 16:16 #1
Excel.
, Excel, , :
EXCEL? , "" 4, . "", , 4. . , ?
, , . :
"" xcel , . "" xcel .
, - , Excel. !
believing
-
20th July 2010 16:24 #2Registered User
Join Date: Oct:2003
Location:
Posts: 4,317
HLOOKUP VLOOKUP. , . ,
-
20th July 2010 16:32 #3
-
20th July 2010 16:44 #4
-
20th July 2010 16:50 #5
-
20th July 2010 16:54 #6
- .
"Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"
-
20th July 2010 17:04 #7
-
20th July 2010 17:07 #8
! , .
"Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"
-
20th July 2010 17:12 #9
-
20th July 2010 17:14 #10
, .
"Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"
-
20th July 2010 18:23 #11
, , , . :
, :
:
:
:
, , . , 1800. - asd12gh. , , asd12gh, 4. 1800/4 - , .
, - , .
.believing
-
20th July 2010 19:00 #12Registered User
Join Date: Oct:2003
Location:
Posts: 4,317
. - A1. - A2. - A3.
B , C .
A3 =VLOOKUP(a2,b:c,2,false)
, ";".
-
22nd July 2010 01:38 #13
:
.
H1 - ..
.
- Data Source, - , . , a A1 .
1 =INDIRECT(A1), , H1.
INDIRECT() .
2 , A1, B1 =INDIRECT(A1)/INDIRECT(B1).
" " ( Data Source), .Last edited by Flower; 22nd July 2010 at 01:45.
-
22nd July 2010 18:30 #14
-
5th August 2010 20:03 #15
, .

, , .
:
A B, VLOOKUP IF- , . , B1 VLOOKUP(A1, Sheet2!B:C,2, false), IF- . B2 , lookup_value 2. .
, , . , B100 VLOOKUP(A100,...). , lookup_value vlookup B999 A999 . , excel , .
, .
. 
:
, copy/paste. , .
. 1 . 1, . , B 100, 101 vlookup(a101, !sheet2, b:c, false).
Last edited by 0wn3r; 5th August 2010 at 20:18.
believing
-
5th August 2010 22:57 #16Registered User
Join Date: Jul:2006
Location: Sofia
Posts: 584
paste - . .
, 2010 .




Reply With Quote

R9 280,
7th May 2023, 21:28 in