#### jpowell79

##### Active Member
Hi Guys,

can anyone help me with this one...

I need to take a value from cell b39. I will then use this value to determine the correct sheet I should be referencing with the word page in front of this.

For example I have various worksheets.

"page0001"
"page0002"
"page0003"

If cell b39 contained "0001", then I'd be looking to reference worksheet "page0001"

I'm guessing I should be using something along the lines of
Code:
``=(INDIRECT("page"&B39)``
??

ok so once I have the worksheet I need to be referencing, I need to look in column M and match the cell which contains the same as cell b37.

I then need to take the value of the adjacent cell in column N that is matched.

So for example,

cell b37 = monday22
cell b39 = 0023

I'd need to look in worksheet "page0023" then look in column M for "monday22"

If "monday22" was in cell M9, then grab the value from N9

Another example

cell b37 = wednesday18
cell b39 = 0145

I'd need to look in worksheet "page0145" then look in column M for "wednesday18"

If "wednesday18" was in cel M14, then grab the value from N14

thanks guys

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### NBVC

##### Well-known Member
Try

=IF(ISNUMBER(MATCH(B37,INDIRECT("'page"&B39&"'!M1:M100"),0)),VLOOKUP(B37,INDIRECT("'page"&B39&"'!M1:N100"),2,0),"")

#### jpowell79

##### Active Member
thanks NBVC mate....worked a treat

Replies
12
Views
218
Replies
20
Views
754
Replies
7
Views
139
Replies
5
Views
197
Replies
5
Views
134

1,195,904
Messages
6,012,212
Members
441,682
Latest member

### 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