View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
confused teacher confused teacher is offline
external usenet poster
 
Posts: 2
Default using multiple vlookups confusion

My skills are limited.....

I am, creating a spreadsheet for a group of children. They can complete 1
of 3 tests according to ability and I want to create a function where if test
type is selected (a,b,or c) then a corresponding lookup table can be selected
to convert a raw score to a grade.

e.g. test a refers to lookup table a, test b to table b etc....

help!!