Conditional formula whereby if A1=Intuit, Then B1=PO Box 1

[An Excel Populated World]

Hi, I hope this is easy. I need to populate excel sheets with addresses so
that if A1 is Intuit, then B1 is The PO Box #. Get where I'm going with
this? I'm going to populate several documents using this kind of logic.
Thanks for any help!

 

[Mike H]

Hi,

You need a lookup table of text/PO Box # like the one below
then in a1 you enter the text and in b1 the formula
=VLOOKUP(A1,G1:H8,2,FALSE)

Note my table is in g1 - h8



Text PO Box #
a 11
b 22
c 33
d 44
e 55
f 66
g 77

Mike

 

[Glenn]

Hi, I hope this is easy. I need to populate excel sheets with addresses so
that if A1 is Intuit, then B1 is The PO Box #. Get where I'm going with
this? I'm going to populate several documents using this kind of logic.
Thanks for any help!

In B1:

=IF(A1="Intuit","The PO Box #","Result if A1 is not Intuit")

If this is not what you are looking for, then you need to add some details to
your description.

 

[An Excel Populated World]

In B1:

=IF(A1="Intuit","The PO Box #","Result if A1 is not Intuit")

If this is not what you are looking for, then you need to add some details to
your description.

Okay Glenn, thanks! I tried that before but I was typing my formula into
the conditional formulas pop-up window instead. I have MANY addresses I need
to do that to, so I'll see if I can use this technique, or see if I have to
go to Mike H's suggestions. Thanks guys!