Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kris
 
Posts: n/a
Default vlookup in several sheets

Hi
I want to make the range in my vlookup formula variable. If for example I
use the account from 2200 into 2300, I want the vlookup to change it's search
range automaticly to this new range
My formula is =vlookup(+c11;+c12;3;false) and c11=206 and c12=tabel2300
--
Greetz
Kris
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default vlookup in several sheets

Try this......

=VLOOKUP(C11,INDIRECT(C12),3,FALSE)

Where the value to be looked up is in C11 and the name of the preferred
Range is in C12.......

Vaya con Dios,
Chuck, CABGx3



"kris" wrote:

Hi
I want to make the range in my vlookup formula variable. If for example I
use the account from 2200 into 2300, I want the vlookup to change it's search
range automaticly to this new range
My formula is =vlookup(+c11;+c12;3;false) and c11=206 and c12=tabel2300
--
Greetz
Kris

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default vlookup in several sheets

Assuming that C12 contains a named range, try...

=VLOOKUP(C11,INDIRECT($C$12),3,FALSE)

Replace commas with semi-colons if your version of Excel uses a
semi-colon as a list separator.

Hope this helps!

In article ,
"kris" wrote:

Hi
I want to make the range in my vlookup formula variable. If for example I
use the account from 2200 into 2300, I want the vlookup to change it's search
range automaticly to this new range
My formula is =vlookup(+c11;+c12;3;false) and c11=206 and c12=tabel2300

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 over multiple sheets SS Excel Worksheet Functions 8 January 13th 06 05:36 PM
add values using vlookup over multi sheets Noemi Excel Discussion (Misc queries) 15 October 23rd 05 05:42 PM
vlookup over 2 sheets? James Excel Worksheet Functions 12 September 14th 05 07:03 PM
Vlookup from 2 different sheets WorkerBee Excel Worksheet Functions 20 February 21st 05 09:57 PM
VLOOKUP across all sheets in a workbook Pawel P. Excel Worksheet Functions 3 January 13th 05 01:20 AM


All times are GMT +1. The time now is 10:23 AM.

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

About Us

"It's about Microsoft Excel"