Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark Brown
 
Posts: n/a
Default Vlookup reference a worksheet

I am attempting to use Vlookup to do a multiple lookup.

I have 7 different worksheets and would like the worksheet names to be one
variable and the worksheet to be a second variable, the vlookup formula is
below. $f$3 is a list of months. I would like to find a way to set the
'a26' to be a variable, so that I can look in different worksheets- depending
on what is input. Each worksheet is an individual person that I need to look
up data on.

=VLOOKUP($F$3,'a26'!$A$2:$J$3639,2,)
Reply
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
Vlookup reference a worksheet Gary Brown Excel Worksheet Functions 1 May 20th 05 07:17 PM
Absolute Worksheet reference number Tony M Excel Discussion (Misc queries) 4 March 21st 05 06:10 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 12:09 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM


All times are GMT +1. The time now is 06:32 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"