If K1 and L1 have the two components 000 and 00 then

=ROUND(IFERROR(VLOOKUP($D196,INDIRECT("'"&K1&"-"&L1&"'!$A$13:$AL
$200"),F$1,FALSE),0),0)

HTH
Kostis Vezerides

On Nov 13, 7:40*pm, Thomas Roos wrote:
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