formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a spreadsheet that was sent to me to do pricing estimates for jobs based on specific job codes. i have the sheet hidden but there seems to be a problem with the formula. once i type in the job code all the info comes up as needed but when there is no code i just get n/a errors. i would be happy to send the spreadsheet to anyone that can help me because it will be easier to see it rather than explain. Please help me. thanks
 
Struggling

Sounds like a VLOOKUP formula that has no match, which would be the case if
there was no job code entered.

Example........

=VLOOKUP(A10, B1:C132,2,FALSE) would return n/a if nothing entered in A10

If this is your case, to hide the n/a you can alter formula to

=IF(ISNA(VLOOKUP(A10,B1:C132,2,FALSE)),"",VLOOKUP(A10,B1:C132,2,FALSE))

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

Excel Drag autofill only part of formula 3
#N/A In Cells 7
finding and replacing 2
Automatically add a column to summary sheet if another worksheet i 2
Removing #N/A from an "If/Then" statement 4
Duplicates Formula 3
Need help with formula 2
if & ands and either indirect or offset - need help fast please 6

Back
Top