View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davidson191 davidson191 is offline
external usenet poster
 
Posts: 5
Default formulas between sheets

this formula works "=VLOOKUP($I$4,'Data Entry'!$A:$AJ,36,FALSE)" but when the
36 is changed to any higher number it does not work. example
"=VLOOKUP($I$4,'Data Entry'!$A:$AJ,37,FALSE)". is 36 the max number of
'lookups' i can have?