I am wondering if anyone can help me. I am trying to create a quote sheet in
Excel. What I am wanting to do is to be able to type a number in the A
column and a decription will appear in the B Column. Example 1 =
Installation. Can anyone tell me how I might do this.

Thank You,
Heather

Assuming you have, on sheet2, a list of numbers in column A and corresponding
descriptions in column B

In B1 of the quote sheet, the formula would be:
=if(A1="","",Vlookup(A1,Sheet2!A:B,2,false))

--
Regards,
Tom Ogilvy


"Heather" wrote:

I am wondering if anyone can help me. I am trying to create a quote sheet in
Excel. What I am wanting to do is to be able to type a number in the A
column and a decription will appear in the B Column. Example 1 =
Installation. Can anyone tell me how I might do this.

Thank You,
Heather

Hi Heather,

With a reference table in g1:h10, a lookup function should do the job :
=Vlookup(a1,g1:h10 ,2)

HTH
Cheers
Carim