IF formula

H

honey do repairs

I am trying to set up a spreadsheet where I can create an invoice. I want to
be able to have a price list in another area of the spreadsheet; enter a code
and have the unit price displayed in the invoice area.

I am not proficient in excel. just know the basics. HELP!
 
S

Sheeloo

Enter the codes in Col A of Sheet2 and corresponding unit price in Col B...
Come back to your Invoice sheet... Let us assume you enter the code in A1 of
this sheet and want the price in B1
Then in B1 enter
=VLOOKUP(A1,Sheet2!A:B,2,False) to get the price

To suppress the #N/A error till you enter a code use
=IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,False) ,"",VLOOKUP(A1,Sheet2!A:B,2,False) )
 
S

Shane Devenshire

Hi,

Similar to Sheeloo's

=VLOOKUP(A1,D1:E9,2,)

Where your table is in D1:E9

In 2007 you can reduce the error handling to

=IFERROR(VLOOKUP(A1,D1:E9,2,),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top