| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
![Gaurav[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
