Lookup array on a sheet based on Cell input

gottimd

Well-known Member
Joined
Jul 29, 2002
Messages
501
In a workbook, I have three sheets labeled Sheet1,sheet2,sheet3.

If on sheet2, in cell a1, I type "Sheet1". How can I get this to make it a functional Vlookup formula on sheet1. I tried Indirect and Index formula's but I am not sure If I am using them correctly.

The actual formula I have right now is:
=IF(M2="Passing",VLOOKUP(F2,INDIRECT("N2")*B75:N120,7,FALSE))

Where N2, is the sheet name that will change in each row. Excel made my formula say ("N2")* but that gets me a "FALSE". What I am hoping it would do, is in cell n2, would be a sheet name, and it would look up that sheet name, same range on all sheets, and return the value.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

Try:

=IF(M2="Passing",VLOOKUP(F2,INDIRECT("'"&N2&"'!B75:N120"),7,FALSE))
 

Forum statistics

Threads
1,147,621
Messages
5,742,188
Members
423,710
Latest member
Duarte85

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top