| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup on mutiple worksheets
Hello All,
I have a worksheet (sheet1) where I would like to do a vlookup in col b1, from data that is in worksheet 2 (sheet2, a1:d100), and worksheet 3 ( sheet 3, a1:d100). the output for the vlookup in sheet 1 is in either sheet 2 or sheet 3. I am new to excel and can do a vlookup by referncing 1 sheet, but having massive problems with referencing 2 sheets. Any help would be very appreciated, and an example spreadsheet with formula would be great Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200802/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup for mutiple rows | Excel Worksheet Functions | |||
| can i.. do a COUNT through mutiple worksheets? | Excel Discussion (Misc queries) | |||
| creating mutiple worksheets | Excel Discussion (Misc queries) | |||
| printing mutiple worksheets on one page | New Users to Excel | |||
| Combine Mutiple Worksheets into one | Excel Discussion (Misc queries) | |||
Threaded Mode
