Results 1 to 15 of 15
Thread: EXCEL
Hybrid View
-
22nd November 2011 11:36 #1Registered User
Join Date: Nov:2011
Location:
Posts: 7
-
22nd November 2011 11:48 #2
,
- VLOOKUP.
- .
, sheet1, sheet 2.
, .
:
=VLOOKUP(A:A;Sheet2!A:B;2;FALSE)
:
=VLOOKUP(A:A;Sheet2!A:B;2;FALSE)
- Sheet1,
=VLOOKUP(A:A;Sheet2!A:B;2;FALSE)
Sheet2 B, ,
=VLOOKUP(A:A;Sheet2!A:B;2;FALSE)
(. - ),
=VLOOKUP(A:A;Sheet2!A:B;2;FALSE) - .
, :
1 Firma 1 20 #N/A
2 Firma 2 50 Firma 2
3 Firma 3 120 #N/A
4 Firma 4 15 #N/A
5 Firma 5 180 Firma 5
6 Firma 6 30 Firma 6
#N/A -
Firma X -
, .
, ."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"
-
22nd November 2011 13:58 #3Registered User
Join Date: Nov:2011
Location:
Posts: 7
2-
D Sheet2 .=VLOOKUP(A:A;Sheet2!A:D;2;FALSE)
?
-
22nd November 2011 14:03 #4
:
=VLOOKUP(A:A;Sheet2!A:D;4;FALSE)
"4" - - , ( ), D - 4 .
: , , #N/A - .
."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"
-
22nd November 2011 14:14 #5Registered User
Join Date: Nov:2011
Location:
Posts: 7
.. #N/A #N/A " 0 "
-
22nd November 2011 14:17 #6




Reply With Quote


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