Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill a cell based on another cell
I'm trying to use the "IF" function.
I can't use the VLOOKUP, it won't work here. Here's what I have: Cell A4=DL or IL Here's the forumla I'm trying to use: In cell b3 "=IF(A4=DL,DL1,IL1)", then I tried =IF(A4=DL,"DL1","IL1") then finally I tried =IF((A4=DL),"DL1","IL1") Which if I undertstand correctly would fill in Cell B3 with a DL1 if DL is entered into cell A4 else IL1 defaults. However, in attempting this I get: #VALUE! regardless of which "formula" I tried to use. I don't see how I can use VLOOKUP because: I need to distinguish my cells first. Here's my table: IL IL1 0001-employee benefit1 IL IL2 0002-employee benefit2 IL IL3 0003-employee benefit3 etc, etc, etc, etc. If I select IL in cell A4 and I attempt to use VLOOKUP I would need IL in the first column of my table. However, if I have 6 rows I want to fill based on my selection in Cell A4, IL in the first column would results in the first finding of IL and all 6 rows would fill with the first row's findings. Help!!?? Please!!?? Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill a cell based on another cell
You need quotes around *all* your text values.
=IF(A4="DL","DL1","IL1") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Debbie" wrote in message ... I'm trying to use the "IF" function. I can't use the VLOOKUP, it won't work here. Here's what I have: Cell A4=DL or IL Here's the forumla I'm trying to use: In cell b3 "=IF(A4=DL,DL1,IL1)", then I tried =IF(A4=DL,"DL1","IL1") then finally I tried =IF((A4=DL),"DL1","IL1") Which if I undertstand correctly would fill in Cell B3 with a DL1 if DL is entered into cell A4 else IL1 defaults. However, in attempting this I get: #VALUE! regardless of which "formula" I tried to use. I don't see how I can use VLOOKUP because: I need to distinguish my cells first. Here's my table: IL IL1 0001-employee benefit1 IL IL2 0002-employee benefit2 IL IL3 0003-employee benefit3 etc, etc, etc, etc. If I select IL in cell A4 and I attempt to use VLOOKUP I would need IL in the first column of my table. However, if I have 6 rows I want to fill based on my selection in Cell A4, IL in the first column would results in the first finding of IL and all 6 rows would fill with the first row's findings. Help!!?? Please!!?? Thanks!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill a cell based on another cell
Almost there.
=IF(A4="DL","DL1","IL1") -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Debbie" wrote in message ... I'm trying to use the "IF" function. I can't use the VLOOKUP, it won't work here. Here's what I have: Cell A4=DL or IL Here's the forumla I'm trying to use: In cell b3 "=IF(A4=DL,DL1,IL1)", then I tried =IF(A4=DL,"DL1","IL1") then finally I tried =IF((A4=DL),"DL1","IL1") Which if I undertstand correctly would fill in Cell B3 with a DL1 if DL is entered into cell A4 else IL1 defaults. However, in attempting this I get: #VALUE! regardless of which "formula" I tried to use. I don't see how I can use VLOOKUP because: I need to distinguish my cells first. Here's my table: IL IL1 0001-employee benefit1 IL IL2 0002-employee benefit2 IL IL3 0003-employee benefit3 etc, etc, etc, etc. If I select IL in cell A4 and I attempt to use VLOOKUP I would need IL in the first column of my table. However, if I have 6 rows I want to fill based on my selection in Cell A4, IL in the first column would results in the first finding of IL and all 6 rows would fill with the first row's findings. Help!!?? Please!!?? Thanks!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill a cell based on another cell
Hi
Try this: =IF(A4="DL","DL1","IL1") Andy. "Debbie" wrote in message ... I'm trying to use the "IF" function. I can't use the VLOOKUP, it won't work here. Here's what I have: Cell A4=DL or IL Here's the forumla I'm trying to use: In cell b3 "=IF(A4=DL,DL1,IL1)", then I tried =IF(A4=DL,"DL1","IL1") then finally I tried =IF((A4=DL),"DL1","IL1") Which if I undertstand correctly would fill in Cell B3 with a DL1 if DL is entered into cell A4 else IL1 defaults. However, in attempting this I get: #VALUE! regardless of which "formula" I tried to use. I don't see how I can use VLOOKUP because: I need to distinguish my cells first. Here's my table: IL IL1 0001-employee benefit1 IL IL2 0002-employee benefit2 IL IL3 0003-employee benefit3 etc, etc, etc, etc. If I select IL in cell A4 and I attempt to use VLOOKUP I would need IL in the first column of my table. However, if I have 6 rows I want to fill based on my selection in Cell A4, IL in the first column would results in the first finding of IL and all 6 rows would fill with the first row's findings. Help!!?? Please!!?? Thanks!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill a cell based on another cell
=IF(A4="DL","DL1","IL1")
"Debbie" wrote: I'm trying to use the "IF" function. I can't use the VLOOKUP, it won't work here. Here's what I have: Cell A4=DL or IL Here's the forumla I'm trying to use: In cell b3 "=IF(A4=DL,DL1,IL1)", then I tried =IF(A4=DL,"DL1","IL1") then finally I tried =IF((A4=DL),"DL1","IL1") Which if I undertstand correctly would fill in Cell B3 with a DL1 if DL is entered into cell A4 else IL1 defaults. However, in attempting this I get: #VALUE! regardless of which "formula" I tried to use. I don't see how I can use VLOOKUP because: I need to distinguish my cells first. Here's my table: IL IL1 0001-employee benefit1 IL IL2 0002-employee benefit2 IL IL3 0003-employee benefit3 etc, etc, etc, etc. If I select IL in cell A4 and I attempt to use VLOOKUP I would need IL in the first column of my table. However, if I have 6 rows I want to fill based on my selection in Cell A4, IL in the first column would results in the first finding of IL and all 6 rows would fill with the first row's findings. Help!!?? Please!!?? Thanks!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill a cell based on another cell
Wow, quick response!!
Thanks to all of you for your help! That's exactly what I needed. :) Merry Christmas! "Debbie" wrote: I'm trying to use the "IF" function. I can't use the VLOOKUP, it won't work here. Here's what I have: Cell A4=DL or IL Here's the forumla I'm trying to use: In cell b3 "=IF(A4=DL,DL1,IL1)", then I tried =IF(A4=DL,"DL1","IL1") then finally I tried =IF((A4=DL),"DL1","IL1") Which if I undertstand correctly would fill in Cell B3 with a DL1 if DL is entered into cell A4 else IL1 defaults. However, in attempting this I get: #VALUE! regardless of which "formula" I tried to use. I don't see how I can use VLOOKUP because: I need to distinguish my cells first. Here's my table: IL IL1 0001-employee benefit1 IL IL2 0002-employee benefit2 IL IL3 0003-employee benefit3 etc, etc, etc, etc. If I select IL in cell A4 and I attempt to use VLOOKUP I would need IL in the first column of my table. However, if I have 6 rows I want to fill based on my selection in Cell A4, IL in the first column would results in the first finding of IL and all 6 rows would fill with the first row's findings. Help!!?? Please!!?? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) |