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!!

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!!

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!!

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!!

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!!

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!!