check box checked - then a result to show in another cell????

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lisa Ann Kashner - 04 Nov 2007 19:04 GMT

Hello,

I would appreciate any help concerning "check boxes".

This concerns a trucking company.

The company has multiple "runs" in different locations/states. Each "run"
pays a different amount.
I would like to use the "check box" for the person to check off the run
he/she did at the end of the day. Then in turn, I need that $ amount to read
out into an "other cell".

For instance, a "run" to the state of Virginia is $37.50, so when that
"Virginia box" is checked (b7) - how can I get the $37.50 dollar amount out
into cell e7?

Thanks in advance! Lisa Ann Kashner

Reply to this Message

Bernard Liengme - 04 Nov 2007 19:18 GMT

This is how I would tackle this problem:

Somewhere on the worksheet out of sight (say stating in cell P1 down) I
would type a list of the "runs". In the column next to it (say starting in
Q1) I would enter the dollar amounts for each "run)

Now over near A1 I would enter some text to tell drivers what to do.
Let's say I want to have the drive enter a "run" in cell D5. The I would use
Data | Data Validation on this cell in such a way that the only valid
entries would be items on my list (P1 to P20 say).

In cell E5 I would use VLOOKUP to get the dollar amount for that run.

I would be happy to send a sample file to your private email. Just send a
message to my private email (omit TRUENORTH.)

best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hello,
>
[quoted text clipped - 15 lines]
>
> Thanks in advance! Lisa Ann Kashner

Reply to this Message