B
bke808
I'm not sure if I'm approaching this from the right angle, but here's
what I'm trying to do. You guys seem to be very helpful so if I'm in
headed in the wrong direction, please show me what I need to do.
I want to type in a number that corresponds to a location for a
specific retail store location and in the next cell, automatically fill
in the name of the store.
EX: If I type in 8 in the store number column, in the store name
column, I want "Pompano Beach" to auto fill. If I type in 4 in the
store number column, I want "Dallas" to auto fill....etc for all of our
store locations.
I've been trying =IF(K5=4,"Dallas",M5) where K5 is the cell associated
with the store number and M5 references a blank cell. I can get that to
work ok, but how do I add multiple conditions to one cell? If I try
=IF(K5=4,"Dallas",M5)=OR(IF(K5=8,"Pompano Beach",M5)), but I get a
#VALUE!.
I've read MS help and tried to search the forums, but I'm coming up
blank. Thanks for your help.
BKE
what I'm trying to do. You guys seem to be very helpful so if I'm in
headed in the wrong direction, please show me what I need to do.
I want to type in a number that corresponds to a location for a
specific retail store location and in the next cell, automatically fill
in the name of the store.
EX: If I type in 8 in the store number column, in the store name
column, I want "Pompano Beach" to auto fill. If I type in 4 in the
store number column, I want "Dallas" to auto fill....etc for all of our
store locations.
I've been trying =IF(K5=4,"Dallas",M5) where K5 is the cell associated
with the store number and M5 references a blank cell. I can get that to
work ok, but how do I add multiple conditions to one cell? If I try
=IF(K5=4,"Dallas",M5)=OR(IF(K5=8,"Pompano Beach",M5)), but I get a
#VALUE!.
I've read MS help and tried to search the forums, but I'm coming up
blank. Thanks for your help.
BKE