ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Converting entered data into a different output (https://www.excelbanter.com/excel-worksheet-functions/196566-converting-entered-data-into-different-output.html)

Seaside Nutty

Converting entered data into a different output
 
1 Attachment(s)
OK this may be a really stupid question but here goes.

I have a spreadsheet for which I want to set up a form for inputing two parameters which will then automatically generate an output (I have attached to this message a simple example of what I mean).

I am sure there is a way I can do this either in a macro or through some sort of LOOKUP function but I can't quite get my head round it.

Any suggestions (other than where I should put my head!) would be welcome.

Note: I am not really an advanced user of Excel but have done basic Macros and simple LOOKUPs before but this is out of my reach.

Thanks folks

David Biddulph[_2_]

Creating a data entry form in excel
 
This isn't a binary group, so attachments aren't permitted. If you upload
your file to a website, you can post a url here, but many readers will be
reluctant to read files from unknown sources.
--
David Biddulph

"Seaside Nutty" wrote in message
...

OK this may be a really stupid question but here goes.

I have a spreadsheet for which I want to set up a data entry form (I
will try to attach to this message)

--
Seaside Nutty





All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com