IF Then

**ganderson** · 06-26-2009, 09:50 AM

I have a form that requires company name and other information to be placed in to 4 differnent cells. I have another area that the information is placed in on the same work sheet. How can I make the information fill in based on a selection in a single cell?

If A3 = 1, then this info
If A3 = 2, then this info
and so on

Attached Document on Quote Page

**tek9step** · 06-26-2009, 09:55 AM

Could you post a sample spreadsheet to work upon it.

Regards

Tek9Step

**tek9step** · 06-26-2009, 10:19 AM

where is the information on the sheet that your are wanting to appear on the Quote. I Can only see contractor name, Phone, Fax but i cannot see company name etc. Please could explain your requirement as to what you want in your Quote form to appear.

Regards

Tek9Step

**ganderson** · 06-26-2009, 10:34 AM

That information is supplied by another sheet. All the other information required in the sheet is linked to a title page.

**jon_wolf69** · 06-26-2009, 10:47 AM

It seems to me that youjust need a vlookup to the other sheet.

All you need to do is put 1, 2, 3 etc in column A on the details sheet. I will call this "Sheet2" then the text in column C then the formula will be

=vlookup(a3,Sheet2!A:C,3,0)

Thanks,
Jon

**tek9step** · 06-26-2009, 10:47 AM

Please could you explain your exact requirment on this workbook that you want.

regards

Tek9Step

**tek9step** · 06-26-2009, 02:29 PM

I have used Vlookup function. Here is a link which explains vlookups.

http://www.techonthenet.com/excel/formulas/vlookup.php

If you still find it difficult to understand just give a shout.

Regards

Tek9Step

If you are happy with any of the results, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post.