How to use vlookup in a range of sheets

[monithis]

I want to know how to make a vlookup from sheet 1 to sheep 7 using column A to column I (in all of the sheets).



All I got is:



=vlookup(A2, 'Sheet1:Sheet7'!A:I, 7,0)



But I got an error. How do I fix the range between columns and sheets?

 

[AlanSidman]

You will need to build a nested IF-Then-Else statement that includes vlookup for each sheet.

 

[monithis]

You will need to build a nested IF-Then-Else statement that includes vlookup for each sheet.

How do I do that?

 

[AlanSidman]

VLOOKUP across multiple sheets in Excel with examples

Formula examples to Vlookup from another worksheet or workbook, Vlookup in multiple sheets, and indirect Vlookup to dynamically pull data from several worksheets into different cells.

www.ablebits.com