RunRyder RC
WATCH
 1 page 689 views POST REPLY
Home🌌Off TopicsOff Topics Main Discussion › Need help from an Excel expert
01-11-2018 04:09 PM  25 months ago
Topic Vote0Post 1
Signman

rrApprentice

Bristol, Virginia

MyPosts All Forum Topic
Need help from an Excel expert
I want to display words in a particular cell that is the result of a different cell measurement (if this is possible). Example...
In column "A' row 2, I want to put the measurement of a shelf tag,"3x1.25"
I want the words "shelf tag" to be displayed in column "B" cell "2". Using the same 2 columns listed, instead of "3x1.25" I would put the measurement of "8.5x14". Then the words "case card" would appear in column "B" cell "2"

3x1.25 is a shelf tag
8.5x14 is a case card

Depending on which of the 2 measurements I enter I would get the correct item case card or shelf tag.

Is this even possible? I don't know a lot about Excel but if I could get this going it would save me a lot of time. Anybody?
Hawk IV, TT.39, Futaba 9C, 401/9253 GV-1 (all gathering dust now)
SHARE  PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 04:32 PM  25 months ago
RM3

rrElite Veteran

Killeen, Texas - USA

MyPosts All Forum Topic
yes it is... what you need is a switch statement... it allows you to determine what value is put into cell based on what value is present in another...
this responds to whatever is in A2...

put this into B2:

=SWITCH(A2,"3x1.25","shelf tag","8.5x14","case card" )

the SWITCH can be as long as needed by adding more key value pairs like:

.... "8.5x14","case card" , "Trex600", "Common Heli" )

you can even add a "default" value (in this case will display Unknown value) if nothing matches up:

. "8.5x14","case card" , "Trex600", "Common Heli", "unknown value" )
showing a preference will only get you into trouble, 90% of everything is crap...
SHARE  PM  EMAIL  Attn:RR  Quote
01-11-2018 05:14 PM  25 months ago
Signman

rrApprentice

Bristol, Virginia

MyPosts All Forum Topic
Excel Expert
Thanks RM3 I'll give this a shot and let you know what happens.
Hawk IV, TT.39, Futaba 9C, 401/9253 GV-1 (all gathering dust now)
SHARE  PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 05:19 PM  25 months ago
AirWolfRC

rrProfessor

42½ N, 83½ W

MyPosts All Forum Topic
The SWITCH command only exists in new excel versions.

Other wise, you can use a LOOKUP command.
With that you build a table somewhere and use it as a cross reference lookup. That way you don't have to repeat all the cross references for each cell you want to use them in.

This works in newer versions of excel also.
SHARE  PM  EMAIL  HOMEPAGE  GALLERY  Attn:RR  Quote
01-11-2018 06:24 PM  25 months ago
Signman

rrApprentice

Bristol, Virginia

MyPosts All Forum Topic
Excel
RM3 that won't work in my version of Excel (Office Home & Student 2007)
Guess I'll have to try that Lookup command that AirWolfRC posted if I can figure out how to do it. Thanks for your time guys I appreciate it.
Hawk IV, TT.39, Futaba 9C, 401/9253 GV-1 (all gathering dust now)
SHARE  PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 07:12 PM  25 months ago
Heli_Splatter

rrElite Veteran

USA

MyPosts All Forum Topic
in cell b2

=IF(A2="3x1.25","is a shelf card","is a case card" )

I know this only works for two types, but that is what you asked.
SHARE  PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 07:14 PM  25 months ago
RM3

rrElite Veteran

Killeen, Texas - USA

MyPosts All Forum Topic
damn dude... you STILL running Windows Vista too?

Well no biggie... here is a screen capture for older versions of excel

you first need to crate a small table of key/value pairs... in example above its column A and B rows 2 - 4

then the formula will be where you want the result to be displayed
showing a preference will only get you into trouble, 90% of everything is crap...
SHARE  PM  EMAIL  Attn:RR  Quote
01-11-2018 09:05 PM  25 months ago
AirWolfRC

rrProfessor

42½ N, 83½ W

MyPosts All Forum Topic
You want old ?

I just got done building a couple of reference machines with Windows-98
- - because I wanted a real dos machine with FAT-32

On a daily basis, I also use Dos, Win-XP, Win-7 & Win-10

Knowing how Microsoft likes to change things around with every version, try and keep all that straight !
SHARE  PM  EMAIL  HOMEPAGE  GALLERY  Attn:RR  Quote
WATCH
 1 page 689 views POST REPLY
Home🌌Off TopicsOff Topics Main Discussion › Need help from an Excel expert
 Print TOPIC  Make Suggestion 

 2  Topic Subscribe

Friday, February 28 - 5:19 pm - Copyright © 2000-2020 RunRyder   EMAILEnable Cookies

Login Here
 New Subscriptions 
 Buddies Online