View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dungan dan dungan is offline
external usenet poster
 
Posts: 411
Default Choose 2 of 6 optional units for grade - formula question

I'm not sure how units, assignments, marks differ in meaning, but it
seems you'd make a table on another sheet that holds the different
values for the units, then use vlookup to pull the correct amount.