heloo
if i have 2 column like these

1 microsoft



and i have 50 companies in another sheet in the same file
(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 column
(microsoft) is equal to the company name corresponding to what number
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 if
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??


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=484642

Se response in .programming

--

HTH

RP
(remove nothere from the email address if mailing direct)


"amrezzat" wrote in
message ...

heloo
if i have 2 column like these

1 microsoft



and i have 50 companies in another sheet in the same file
(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 column
(microsoft) is equal to the company name corresponding to what number
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 if
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(A
4=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??


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile:
http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=484642

On Sun, 13 Nov 2005 05:53:35 -0600, amrezzat
wrote:


heloo
if i have 2 column like these

1 microsoft



and i have 50 companies in another sheet in the same file
(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 column
(microsoft) is equal to the company name corresponding to what number
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 if
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??

Excel only allows you to nest seven functions. But you should use VLOOKUP for
this problem:

=VLOOKUP(A4,'c'!G1:H50,2,FALSE)

Adjust the range on sheet c to reflect where your table is located.


--ron