Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using If function
version i use is Excel 2002
Name of file1 is : Workbook1 Name of file2 is: Work book2 Workbook1 - contains two fields (Age & Name) Age Name 21 tom 22 peter 23 harry Workbook2 - also contains two fields (Age & Name) when i enter the age in workbook2 in cell(a1), i need to get the name of concerned person in cell b1. For this i have put this formula in workbook2 in cell b1 =if(a1=[Workbook1] a1,b1, if(a1=[workbook1]a2,b2, if(a1=[workbook1]a3,b3))) And this worked. I have just given an example above. The actual data which i have is a big one. So the above formula is a very complex for me to use. IS THERE ANY OTHER FORMULA WHICH I COULD USE? |
#2
|
|||
|
|||
Antony,
Would VLOOKUP be an option? See excel help. "Antony Peter" wrote in message ... version i use is Excel 2002 Name of file1 is : Workbook1 Name of file2 is: Work book2 Workbook1 - contains two fields (Age & Name) Age Name 21 tom 22 peter 23 harry Workbook2 - also contains two fields (Age & Name) when i enter the age in workbook2 in cell(a1), i need to get the name of concerned person in cell b1. For this i have put this formula in workbook2 in cell b1 =if(a1=[Workbook1] a1,b1, if(a1=[workbook1]a2,b2, if(a1=[workbook1]a3,b3))) And this worked. I have just given an example above. The actual data which i have is a big one. So the above formula is a very complex for me to use. IS THERE ANY OTHER FORMULA WHICH I COULD USE? |
#3
|
|||
|
|||
What happens if there are more than 1 of an age?
-- HTH RP (remove nothere from the email address if mailing direct) "Antony Peter" wrote in message ... version i use is Excel 2002 Name of file1 is : Workbook1 Name of file2 is: Work book2 Workbook1 - contains two fields (Age & Name) Age Name 21 tom 22 peter 23 harry Workbook2 - also contains two fields (Age & Name) when i enter the age in workbook2 in cell(a1), i need to get the name of concerned person in cell b1. For this i have put this formula in workbook2 in cell b1 =if(a1=[Workbook1] a1,b1, if(a1=[workbook1]a2,b2, if(a1=[workbook1]a3,b3))) And this worked. I have just given an example above. The actual data which i have is a big one. So the above formula is a very complex for me to use. IS THERE ANY OTHER FORMULA WHICH I COULD USE? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions |