I want to create a form for a web page. When customers place a 4 digit number
in a box - the adjoing box will give them a response based on their input.
Example: Customer enters (first box either or choice) 1 or 2 items.
second box - post code (4 digits) customer enters 4 digits
Third box - shows $ amt based on customer choices of first two boxes.

I can not find this calc anywhere!!

Can you help?

Take a look at the LOOKUP and VLOOKUP functions. You'll need to create a
table correlating post codes with prices. Assuming 2 items cost twice as much
as one item, the formula then becomes something like:

=Cell1 * VLOOKUP(Cell2,YourTable,2,FALSE)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Littlefeather" wrote:

I want to create a form for a web page. When customers place a 4 digit number
in a box - the adjoing box will give them a response based on their input.
Example: Customer enters (first box either or choice) 1 or 2 items.
second box - post code (4 digits) customer enters 4 digits
Third box - shows $ amt based on customer choices of first two boxes.

I can not find this calc anywhere!!

Can you help?