View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thomas Roos Thomas Roos is offline
external usenet poster
 
Posts: 8
Default Reference Sheets in a Vlookup

I have the following Vlookup formula

=ROUND(IFERROR(VLOOKUP($D196,'000-00'!$A$13:$AL$200,F$1,FALSE),0),0)

I want to have '000-00' change based on combining two cells.
My worksheet has 100 plus sheets and want to be able to reference the sheet
location based on two other cells.
Is there a way to do this?

thanks
--
Tom