| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup - Multiple Sheet HELP PLEASEEEEEEEEE
Please I need help in vlook up using macro. I have multiple sheets in a Wk
book and would like to lookup E5 from data range in another workbook and return column 2 data. I want the result to be displayed in A10 across multiple sheets based on their corresponding E5 cell lookup value. Wk Book 1 Sheet 1 Cell E5 J45Offe_1 Sheet 2 Cell E5 Pl09Kiy_6 Wkbook 2 Cell A1 J45Offe_1 CEll B1 JungleBoy Cell A2 Pl09Kiy_6 Cell B2 HuntingWizz Final Output For Sheet 1 Cell A10 = JungleBoy For Sheet 2 Cell A10 = HuntingWizz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP - columnar sheet with multiple matches - need to return a | Excel Worksheet Functions | |||
| How to VLOOKUP multiple sheets and each sheet have 65536 rows? | Excel Worksheet Functions | |||
| Using Vlookup with multiple sheet | Excel Worksheet Functions | |||
| vlookup in a multiple sheet file | Excel Worksheet Functions | |||
| connecting multiple cells to new sheet (VLOOKUP?IF?) | Excel Worksheet Functions | |||
Threaded Mode
