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,),"")
 
Top