RunRyder RC
WATCH
 1 page 572 views POST REPLY
HomeOff Topics › Need help from an Excel expert
01-11-2018 04:09 PM  9 months agoPost 1
Signman

rrApprentice

Bristol, Virginia

My Posts: All  Forum  Topic

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)

PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 04:32 PM  9 months agoPost 2
RM3

rrElite Veteran

Killeen, Texas - USA

My Posts: 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...

PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 05:14 PM  9 months agoPost 3
Signman

rrApprentice

Bristol, Virginia

My Posts: 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)

PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 05:19 PM  9 months agoPost 4
AirWolfRC

rrProfessor

42½ N, 83½ W

My Posts: 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.

PM  EMAIL  HOMEPAGE  GALLERY  Attn:RR  Quote
01-11-2018 06:24 PM  9 months agoPost 5
Signman

rrApprentice

Bristol, Virginia

My Posts: 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)

PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 07:12 PM  9 months agoPost 6
Heli_Splatter

rrElite Veteran

USA

My Posts: 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.

PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 07:14 PM  9 months agoPost 7
RM3

rrElite Veteran

Killeen, Texas - USA

My Posts: 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...

PM  EMAIL  GALLERY  Attn:RR  Quote
01-11-2018 09:05 PM  9 months agoPost 8
AirWolfRC

rrProfessor

42½ N, 83½ W

My Posts: 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 !

PM  EMAIL  HOMEPAGE  GALLERY  Attn:RR  Quote
WATCH
 1 page 572 views POST REPLY
HomeOff Topics › Need help from an Excel expert
 Print TOPIC  Make Suggestion 

 2  Topic Subscribe

Friday, October 19 - 11:53 am - Copyright © 2000-2018 RunRyder   EMAILEnable Cookies

The RC discussion world needs to consolidate. RR is now one choice for that. Its software is cutting edge. It hosts on-topic advertising. Help RR increase traffic buy making suggestions, posting in RR's new areas (sites) and by spreading the word.

The RunRyder Difference

• Category system to allow Rep/Vendor postings.
• Classifieds with sold (hidden) category.
• Classifieds with separate view new.
• Answer PMs offsite via email reply.
• Member gallery photos with advanced scripting.
• Gallery photo viewer integrated into postings.
• Highly refined search with advanced back end.
• Hosts its own high end fast response servers.
• Hosts thousands of HD event coverage videos.
• Rewrote entire code base with latest technology.
• No off-topic (annoying) click bait advertising.
Login Here
 New Subscriptions 
 Buddies Online