Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple formula
I have tabs for each week of the year, and on each tab I need to enter a
vlookup formula to see whether the content is situated in column B on the preceding weeks tabs. i.e Data in B1 on tab wk3 eq 123456. I need a formula to enter in B1 to see whether that text is situated in column B on tabs wk1 and wk2. That same formula will have to be used come wk52, when its has to check the previous 51 tabs to see if data is there. Can any on help. Never had a vlookup to do, that is this difficult |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple formula
holyman,
There are no tools that will look across multiple worksheets. Look at "Data across multiple sheets" at http://www.smokeylake.com/excel/excel_truths.htm. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "holyman" wrote in message ... I have tabs for each week of the year, and on each tab I need to enter a vlookup formula to see whether the content is situated in column B on the preceding weeks tabs. i.e Data in B1 on tab wk3 eq 123456. I need a formula to enter in B1 to see whether that text is situated in column B on tabs wk1 and wk2. That same formula will have to be used come wk52, when its has to check the previous 51 tabs to see if data is there. Can any on help. Never had a vlookup to do, that is this difficult |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions |