Model # lookup spreadsheet

  • Thread starter Thread starter Doctor Hurt
  • Start date Start date
D

Doctor Hurt

How would I create a spreadsheet that would indicate what type Product
is when a model # is put in multiple cells?

Here is my situation, I'm in the HVAC business and would like to be
able to put individual letters, (or numbers) in cells A1 through A20 or
so, and return an answer in maybe B2 stating that the product is a
Brand X, Air Handler, with gas heat and 3 tons of cooling etc.?

In some products the combined cells, (the first three letters/numbers
for instance), indicate a particular type etc. In this instance how
would I avoid repeating Brand X three times?

=IF(A1>="XOX","Brand X",IF(A1=XYX,Brand
X,IF(A1>5,4,IF(A1>3,3,IF(A1>=1,2,IF(A1<1,0))))))

Thanks in advance for any help...

Doctor Hurt
 
Dr

Do you already have a list, declaring x refers to Brand X, and O refers to
Air Handler (or whatever)? Am I on the right track, of have I misunderstood
completely? Do you want the X you type to return Brand X, the O to return
Air Handler etc?

Andy.
 
Andy said:
*Dr

Do you already have a list, declaring x refers to Brand X, and O
refers to
Air Handler (or whatever)?
Andy.
*
Click to expand...

Yes,
A specific example of one brand would be as follows,
-TTA, TTB, TTN, TTP, TTR, TTX and TTY would equal a "Split Cooling"
system, this would be in cell A1, A2 and A3?
-within this same brand, TCC, TCH, TCD, TCX, TCM and TCY would equate
to "Packaged Cooling"

- However other Brands use individual places in their nomenclature to
mean a specific thing, (not a group of three), such "Q" equals Heat
Pump.

I am using Excel 97 and it is my understanding that you cannot nest
more than 7 IF's, some of these have more choices than that, and that
is what I have been playing with. Am I on the right track at all?

Thanks for your reply Andy,
Doctor
 
Dr

If you already have your list of information laid out, it should be fairly
straightforward.

So in column A you might have
A
B
C
with corresponding info in column B:
alpha
bravo
charlie

If you have your 'code' in C1 (eg BAC), you are expecting to get (in D1)
bravo alpha charlie

Is that right?

Andy.
 
Would my "TTA, TTB, TTN, TTP, TTR, TTX and TTY" be the same as your
Column "A, B and C"? If so, this was not the way I was trying it.
I need to set it up this way looks like.....

Thanks for the replys
 
Back
Top