| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup in a multiple sheet file
Hi,
I am trying to use the vlookup function to search for data in another file that has multiple sheets (25). The worksheets all have different names ( not just 1 to 25). The data I am looking for is all set up with the same columns on each page so I can look in column F on each page. So, how can I vlookup on 25 pages at once rather than using 25 different vlookups. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
| Variabilize File Path or File Name in SumProduct (and Vlookup too) | Excel Worksheet Functions | |||
| connecting multiple cells to new sheet (VLOOKUP?IF?) | Excel Worksheet Functions | |||
| Neet to use Excel to read in multiple-sheet file | Excel Worksheet Functions | |||
| printing multiple sheet tabs to image file | Excel Discussion (Misc queries) | |||
Threaded Mode
