LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brutus
 
Posts: n/a
Default VLOOKUP on multiple worksheets

I have a very large spreadsheet with 4 worksheets. I need to do a VLOOKUP
for a value that may occur on any of the worksheets. I have been unable to
write a formula that will work. I cannot combine the worksheets into one
huge sheet. All the columns are laid out the same all all the sheets so
once I find the item I want I can display the information I want easily.

Dave


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif with multiple worksheets Cbh35711 Excel Worksheet Functions 3 August 9th 05 02:49 PM
Printing Multiple Worksheets Linda Excel Discussion (Misc queries) 1 August 8th 05 05:12 PM
Need to have multiple worksheets use a single worksheet storm5527 Excel Worksheet Functions 1 April 22nd 05 11:25 AM
Extracting data from multiple worksheets into a list mnirula Excel Worksheet Functions 16 February 25th 05 08:52 PM
vlookup over multiple worksheets Neil Excel Worksheet Functions 3 December 16th 04 08:19 PM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"