If you open the spreadsheet, I have hightlighted in bright yellow the comments that will tell what formulas I need help on. I should need two formulas corrected but maybe someone knows a better way and can 'skip a step' and only use one formula. Either way will be very helpful. Thanks in advance.
hi ugabuildawg98, try this in B74:
=IF(ISNA(VLOOKUP(B2,$A$37:$C$68,3,FALSE)),"",VLOOKUP(B2,$A$37:$C$68,3,FALSE))
or if nobody uses this file but you since you using Excel 2007:
=IFERROR(VLOOKUP(B2,$A$37:$C$68,3,FALSE),"")
your AVERAGE will work after this is done
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Great. Thanks Benishiryo!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks