| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
VLOOKUP across all sheets in a workbook
what is need is something like:
=VLOOKUP(A2;'Sheet1:Sheet2'!A:G;5;FALSE) but of course it will not work in such way. I jsut need the vlookup to search not in one but ALL sheets and there are around a 1000, so instead of repeating the function =VLOOKUP(A2;Sheet(1)!A:G;5;FALSE) on each sheet i would like the function to go through all sheets at once) Best Regards, Pawel P. (X) is the sheet number :-) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
| copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
| how can i link sheets in my excel workbook | Excel Worksheet Functions | |||
| There is no way to view multiple sheets from one workbook | Excel Discussion (Misc queries) | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
