Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help me on if function please
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? -- amrezza ----------------------------------------------------------------------- amrezzat's Profile: http://www.excelforum.com/member.php...fo&userid=2876 View this thread: http://www.excelforum.com/showthread.php?threadid=48464 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help me on if function please
In Sheet2 B1
=VLOOKUP(A1;Sheet1!A1:B1000;2;False) -- 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=484641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |