IF Functions

  • Thread starter Thread starter bke808
  • Start date Start date
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
 
Your best bet is to create a two column table, e.g. store numbers in
a1:a10 and corresponding store names in b1:b10 then use this formula

=VLOOKUP(K5,$a$1:$b$10,2,0)
 
That's exactly what I need. Thanks!!!
BKE
Your best bet is to create a two column table, e.g. store numbers in
a1:a10 and corresponding store names in b1:b10 then use this formula

=VLOOKUP(K5,$a$1:$b$10,2,0)
Click to expand...
 
Back
Top