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
 
Back
Top