Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
I have a table with names going down the column, and then numbers in the 7
columns to the side. Below that, I created another column of all the possible numbers. I then created a conditional to look through each number column above and see if it will match the corresonding number of the cell I am in below. If it matches, I need to it to display the name that corresponds to the number match. However, it seems that it wont display the name for some reason. I know the formula is right because if I were to manipulate it so it would display a number instead, this works. It seems that the problem is in displaying the name as it's not a number. Anyone know an additional function I need to insert to get the name displayed? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
If you have to return BULSY, in the formula write "BULSY"
Hope this helps. "bulsy" wrote in message ... I have a table with names going down the column, and then numbers in the 7 columns to the side. Below that, I created another column of all the possible numbers. I then created a conditional to look through each number column above and see if it will match the corresonding number of the cell I am in below. If it matches, I need to it to display the name that corresponds to the number match. However, it seems that it wont display the name for some reason. I know the formula is right because if I were to manipulate it so it would display a number instead, this works. It seems that the problem is in displaying the name as it's not a number. Anyone know an additional function I need to insert to get the name displayed? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
Below is an example of what I have built. I want it to look at the list in
Col B and match it to the corresponding number below, then to display "Steve" next to 1, "Joe" next to 2, and so on... I want this all to be automatic so that in subsequent columns when the number changes, the name changes below as well. Col A Col B Col C Adam 4 2 Steve 1 3 Frank 3 1 Joe 2 4 1: Steve Frank 2: Joe Adam 3: Frank Steve 4: Adam Joe "Gaurav" wrote: If you have to return BULSY, in the formula write "BULSY" Hope this helps. "bulsy" wrote in message ... I have a table with names going down the column, and then numbers in the 7 columns to the side. Below that, I created another column of all the possible numbers. I then created a conditional to look through each number column above and see if it will match the corresonding number of the cell I am in below. If it matches, I need to it to display the name that corresponds to the number match. However, it seems that it wont display the name for some reason. I know the formula is right because if I were to manipulate it so it would display a number instead, this works. It seems that the problem is in displaying the name as it's not a number. Anyone know an additional function I need to insert to get the name displayed? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
=IF($A2=B$7,$A$7,IF($A2=B$8,$A$8,IF($A2=B$9,$A$9,I F($A2=B$10,$A$10,""))))
Drag down and right. IF(B1=1,"Steve",IF(B1=2,"Joe",IF(B1=3,"Frank",IF(B 1=4 "bulsy" wrote in message ... Below is an example of what I have built. I want it to look at the list in Col B and match it to the corresponding number below, then to display "Steve" next to 1, "Joe" next to 2, and so on... I want this all to be automatic so that in subsequent columns when the number changes, the name changes below as well. Col A Col B Col C Adam 4 2 Steve 1 3 Frank 3 1 Joe 2 4 1: Steve Frank 2: Joe Adam 3: Frank Steve 4: Adam Joe "Gaurav" wrote: If you have to return BULSY, in the formula write "BULSY" Hope this helps. "bulsy" wrote in message ... I have a table with names going down the column, and then numbers in the 7 columns to the side. Below that, I created another column of all the possible numbers. I then created a conditional to look through each number column above and see if it will match the corresonding number of the cell I am in below. If it matches, I need to it to display the name that corresponds to the number match. However, it seems that it wont display the name for some reason. I know the formula is right because if I were to manipulate it so it would display a number instead, this works. It seems that the problem is in displaying the name as it's not a number. Anyone know an additional function I need to insert to get the name displayed? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
enter this formula in B2 and then drag it as I assumed that your names are
from A1 to A4 and the table below starts from A7. "Gaurav" wrote in message ... =IF($A2=B$7,$A$7,IF($A2=B$8,$A$8,IF($A2=B$9,$A$9,I F($A2=B$10,$A$10,"")))) Drag down and right. IF(B1=1,"Steve",IF(B1=2,"Joe",IF(B1=3,"Frank",IF(B 1=4 "bulsy" wrote in message ... Below is an example of what I have built. I want it to look at the list in Col B and match it to the corresponding number below, then to display "Steve" next to 1, "Joe" next to 2, and so on... I want this all to be automatic so that in subsequent columns when the number changes, the name changes below as well. Col A Col B Col C Adam 4 2 Steve 1 3 Frank 3 1 Joe 2 4 1: Steve Frank 2: Joe Adam 3: Frank Steve 4: Adam Joe "Gaurav" wrote: If you have to return BULSY, in the formula write "BULSY" Hope this helps. "bulsy" wrote in message ... I have a table with names going down the column, and then numbers in the 7 columns to the side. Below that, I created another column of all the possible numbers. I then created a conditional to look through each number column above and see if it will match the corresonding number of the cell I am in below. If it matches, I need to it to display the name that corresponds to the number match. However, it seems that it wont display the name for some reason. I know the formula is right because if I were to manipulate it so it would display a number instead, this works. It seems that the problem is in displaying the name as it's not a number. Anyone know an additional function I need to insert to get the name displayed? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
Im not sure if Im explaining this correctly. In the blank lines below, this
is the formula that I have entered: {=SUM(IF(B1:B4=A6, A1:A4," "))} As I said before, if the names were numbers (say, 100 - 104) it would return the number value, but since it's a name it returns a "0". I want to be able to automatically fill in the blank spaces using the columns. Col A Col B Col C Adam 4 2 Steve 1 3 Frank 3 1 Joe 2 4 1: ____ ____ 2: ____ ____ 3: ____ ____ 4: ____ ____ "Gaurav" wrote: =IF($A2=B$7,$A$7,IF($A2=B$8,$A$8,IF($A2=B$9,$A$9,I F($A2=B$10,$A$10,"")))) Drag down and right. IF(B1=1,"Steve",IF(B1=2,"Joe",IF(B1=3,"Frank",IF(B 1=4 "bulsy" wrote in message ... Below is an example of what I have built. I want it to look at the list in Col B and match it to the corresponding number below, then to display "Steve" next to 1, "Joe" next to 2, and so on... I want this all to be automatic so that in subsequent columns when the number changes, the name changes below as well. Col A Col B Col C Adam 4 2 Steve 1 3 Frank 3 1 Joe 2 4 1: Steve Frank 2: Joe Adam 3: Frank Steve 4: Adam Joe "Gaurav" wrote: If you have to return BULSY, in the formula write "BULSY" Hope this helps. "bulsy" wrote in message ... I have a table with names going down the column, and then numbers in the 7 columns to the side. Below that, I created another column of all the possible numbers. I then created a conditional to look through each number column above and see if it will match the corresonding number of the cell I am in below. If it matches, I need to it to display the name that corresponds to the number match. However, it seems that it wont display the name for some reason. I know the formula is right because if I were to manipulate it so it would display a number instead, this works. It seems that the problem is in displaying the name as it's not a number. Anyone know an additional function I need to insert to get the name displayed? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
why dont you do this.
=IF($A7=B$1,$A$1,IF($A8=B$2,$A$2,IF($A9=B$3,$A$3,I F($A10=B$4,$A$4,"")))) earlier formula was returning numbers in the upper table looking at the lower table. this should return names in the lower table looking at the upper table. "bulsy" wrote in message ... Im not sure if Im explaining this correctly. In the blank lines below, this is the formula that I have entered: {=SUM(IF(B1:B4=A6, A1:A4," "))} As I said before, if the names were numbers (say, 100 - 104) it would return the number value, but since it's a name it returns a "0". I want to be able to automatically fill in the blank spaces using the columns. Col A Col B Col C Adam 4 2 Steve 1 3 Frank 3 1 Joe 2 4 1: ____ ____ 2: ____ ____ 3: ____ ____ 4: ____ ____ "Gaurav" wrote: =IF($A2=B$7,$A$7,IF($A2=B$8,$A$8,IF($A2=B$9,$A$9,I F($A2=B$10,$A$10,"")))) Drag down and right. IF(B1=1,"Steve",IF(B1=2,"Joe",IF(B1=3,"Frank",IF(B 1=4 "bulsy" wrote in message ... Below is an example of what I have built. I want it to look at the list in Col B and match it to the corresponding number below, then to display "Steve" next to 1, "Joe" next to 2, and so on... I want this all to be automatic so that in subsequent columns when the number changes, the name changes below as well. Col A Col B Col C Adam 4 2 Steve 1 3 Frank 3 1 Joe 2 4 1: Steve Frank 2: Joe Adam 3: Frank Steve 4: Adam Joe "Gaurav" wrote: If you have to return BULSY, in the formula write "BULSY" Hope this helps. "bulsy" wrote in message ... I have a table with names going down the column, and then numbers in the 7 columns to the side. Below that, I created another column of all the possible numbers. I then created a conditional to look through each number column above and see if it will match the corresonding number of the cell I am in below. If it matches, I need to it to display the name that corresponds to the number match. However, it seems that it wont display the name for some reason. I know the formula is right because if I were to manipulate it so it would display a number instead, this works. It seems that the problem is in displaying the name as it's not a number. Anyone know an additional function I need to insert to get the name displayed? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function help
you cant SUM names.
"bulsy" wrote in message ... Im not sure if Im explaining this correctly. In the blank lines below, this is the formula that I have entered: {=SUM(IF(B1:B4=A6, A1:A4," "))} As I said before, if the names were numbers (say, 100 - 104) it would return the number value, but since it's a name it returns a "0". I want to be able to automatically fill in the blank spaces using the columns. Col A Col B Col C Adam 4 2 Steve 1 3 Frank 3 1 Joe 2 4 1: ____ ____ 2: ____ ____ 3: ____ ____ 4: ____ ____ "Gaurav" wrote: =IF($A2=B$7,$A$7,IF($A2=B$8,$A$8,IF($A2=B$9,$A$9,I F($A2=B$10,$A$10,"")))) Drag down and right. IF(B1=1,"Steve",IF(B1=2,"Joe",IF(B1=3,"Frank",IF(B 1=4 "bulsy" wrote in message ... Below is an example of what I have built. I want it to look at the list in Col B and match it to the corresponding number below, then to display "Steve" next to 1, "Joe" next to 2, and so on... I want this all to be automatic so that in subsequent columns when the number changes, the name changes below as well. Col A Col B Col C Adam 4 2 Steve 1 3 Frank 3 1 Joe 2 4 1: Steve Frank 2: Joe Adam 3: Frank Steve 4: Adam Joe "Gaurav" wrote: If you have to return BULSY, in the formula write "BULSY" Hope this helps. "bulsy" wrote in message ... I have a table with names going down the column, and then numbers in the 7 columns to the side. Below that, I created another column of all the possible numbers. I then created a conditional to look through each number column above and see if it will match the corresonding number of the cell I am in below. If it matches, I need to it to display the name that corresponds to the number match. However, it seems that it wont display the name for some reason. I know the formula is right because if I were to manipulate it so it would display a number instead, this works. It seems that the problem is in displaying the name as it's not a number. Anyone know an additional function I need to insert to get the name displayed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |