Re: Function for Auto Populate

How about posting the *actual* formula that you're using?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<randfan@xxxxxxxxxx> wrote in message
news:1122516603.068111.96800@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Beginner here. I'm looking for a way to auto-populate one cell based
> on, or "triggered" by the input from a previous cell (or selection from
> a drop down validation list). The "IF" function only seems to work
> with numerical values, or only if the "logical test" is a numerical or
> single letter symbol. A simple example of what I am looking for is
> below:
>
> If I type "Harold Smith" in A1, I want his supervisor, "Scott Jones",
> to automatically populate in B2.
>
> I tried to make it happen using the "IF" function:
>
> Logical_test Harold Smith
> Value_if_true "Scott Jones"
> Value_if_false "None"
>
> I get the "#NAME?" result. Any suggestions would be appreciated.
>
> Tim Hopkins
>

.