Formulas with Dynamic Reference to User selected worksheet

[daylilytrader]

Please help!! I have a combo box that allows the user to select a worksheet (‘Revenue Data’ or ‘Volume Data’). The user’s selection is linked to a cell location (P3). I have data tables containing formulas/functions that need to dynamically change in reference to the chosen worksheet.

Sample formula:
<o></o>
=IF($F23="","",IF(ISERROR(VLOOKUP($F23,'Revenue Data'!$C:$EH,14,FALSE)),"",IF(VLOOKUP($F23,'Revenue Data'!$C:$EH,14,FALSE)=0,"",VLOOKUP($F23,'Revenue Data'!$C:$EH,14,FALSE)<o></o>
<o></o>
How do I modify the formula to dynamically reference the user selected worksheet named in cell P3?

Thanks!

 

[Robert Mika]

Please help!! I have a combo box that allows the user to select a worksheet (‘Revenue Data’ or ‘Volume Data’). The user’s selection is linked to a cell location (P3). I have data tables containing formulas/functions that need to dynamically change in reference to the chosen worksheet.

Sample formula:
<o></o>
=IF($F23="","",IF(ISERROR(VLOOKUP($F23,'Revenue Data'!$C:$EH,14,FALSE)),"",IF(VLOOKUP($F23,'Revenue Data'!$C:$EH,14,FALSE)=0,"",VLOOKUP($F23,'Revenue Data'!$C:$EH,14,FALSE)<o></o>
<o></o>
How do I modify the formula to dynamically reference the user selected worksheet named in cell P3?

Thanks!

Hello and wellcome.
Try:
Excel INDIRECT Function Tutorial