Vlookup in multiple pages.

[Belleke]

I have this formula:

=VLOOKUP(H1;Info1!A:B;2;FALSE)

So when I type a number in H1, the value should appear in columm B, next to the number.
This is working for 1 worksheet, but I want it working for al worksheets.
In my example, if I type 5 ,the word Praag Should appear next to Number 5.

 

[vletm]

Check:

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

 

[Belleke]

Thanks,I already looked there, but after a year in hospital, i can't follow these guidings anymore, i need simpler answers.

 

[AliGW]

In B2 copied down:

=IFERROR(VLOOKUP(A2,INDIRECT("'Info"&$H$1&"'!A:B"),2,FALSE),"")

 

[vletm]

Belleke​

This works ...

 

[Belleke]

Hoi AliGW,
Thank you my dear, it works perfect and vletm thanks also.

 

[vletm]

Belleke​

Your original ... was ... when I type a number in H1, the value should appear in columm B, next to the number.
My should work as You've written.

 

[AliGW]

You're welcome.

 

[pecoflyer]

IMO referencing entire columns is bad practice. Use Excel Tables instead

 

[AliGW]

It is, but if tables aren't possible, you can easily limit the range:

=IFERROR(VLOOKUP(A2,INDIRECT("'Info"&$H$1&"'!A1:B10000"),2,FALSE),"")

 

[vletm]

Belleke​

Same with Tables.

 

[Belleke]

@ vletm, I like the solution with tables.