Results 1 to 9 of 9
Thread: Excel
Hybrid View
-
19th April 2012 17:54 #1Registered User
Join Date: Nov:2011
Location:
Posts: 7
Excel
, Excel .
... http://dox.bg/files/dw?a=1331f3324d
Sheet- sheet2 Sheet 1.
:Sheet1 Sheet2 2 B . 0. e=IF(ISNA(VLOOKUP(A:A;Sheet2!A:B;2;FALSE) );0;VLOOKUP(A:A;Sheet2!A:B;2;FALSE))
-
20th April 2012 09:36 #2
IF, VLOOKUP?
0 , ?
VLOOKUP ."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 April 2012 10:36 #3
-
20th April 2012 11:06 #4
( ):
Code:=IF(ISNA(VLOOKUP(C:C;2!C:D;4;FALSE));0;VLOOKUP(C:C;2!C:D;4;FALSE)) =IF(ISNA(VLOOKUP(C:C;2!C:D;1;FALSE));0;VLOOKUP(C:C;2!C:D;2;FALSE)) =IF(ISNA(VLOOKUP(C:C;2!C:E;5;FALSE));0;VLOOKUP(C:C;2!C:E;5;FALSE)) =IF(ISNA(VLOOKUP(C:C;2!C:E;1;FALSE));0;VLOOKUP(C:C;2!C:E;3;FALSE))
VLOOKUP(lookup_value,table_array,col_ind ex_num,range_lookup)
col_index_num table_array!
-
20th April 2012 13:31 #5
-
23rd April 2012 10:29 #6Registered User
Join Date: Nov:2011
Location:
Posts: 7
- skrubalov ... col_index 2! 1!. ? .
-
20th April 2012 10:53 #7




Reply With Quote
7th May 2023, 16:02 in PC