# Formulas with Dynamic Reference to User selected worksheet

##### New Member
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!

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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

Replies
4
Views
426
Replies
2
Views
206
Replies
2
Views
141
Replies
2
Views
88
Replies
0
Views
232

1,203,045
Messages
6,053,187
Members
444,644
Latest member
keepontruckinc4

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back