A
amrezzat
heloo
if i have 2 column like these
1 microsoft
and i have 50 companies in another sheet in the same fil
(sakhr,intel,microsoft,a,b,.....) each company have a number
example
1 sakhr
2 intel
..
..
50 z
and i want to make the first cell value in the second colum
(microsoft) is equal to the company name corresponding to what numbe
person write in the first cell in the first column(1.....50)
how can i do it
as every time i try to write the if function
an error occured at the 9th step, and its only want me to enter 8 i
function
IF(A4=44;'c'!G$44;IF(A4=45;'c'!G$45;IF(A4=46;'c'!G$46;IF(A4=47;'c'!G$47;IF(A4=48;'c'!G$48;IF(A4=49;'c'!G$49;IF(A4=50;'c'!G$50)))))))
i cant write more than that ????????
how can i solve that problem?
if i have 2 column like these
1 microsoft
and i have 50 companies in another sheet in the same fil
(sakhr,intel,microsoft,a,b,.....) each company have a number
example
1 sakhr
2 intel
..
..
50 z
and i want to make the first cell value in the second colum
(microsoft) is equal to the company name corresponding to what numbe
person write in the first cell in the first column(1.....50)
how can i do it
as every time i try to write the if function
an error occured at the 9th step, and its only want me to enter 8 i
function
IF(A4=44;'c'!G$44;IF(A4=45;'c'!G$45;IF(A4=46;'c'!G$46;IF(A4=47;'c'!G$47;IF(A4=48;'c'!G$48;IF(A4=49;'c'!G$49;IF(A4=50;'c'!G$50)))))))
i cant write more than that ????????
how can i solve that problem?