| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Are multiple Vlookup's possible?
Hi all, i am using this =VLOOKUP(F1,TiedEquip,4,FALSE) on my worksheet and it is located in D1, what i would like to do is a VLookup like this.....=VLookup(F1,C1 ,4,FALSE), where C1 on the same sheet would be the name of the named range to look at, this way i can have a drop down list of names which would change the contents of D1 based on the value in F1 because as i change the name in C1 it would look to a different named range! Don't know whether i was clear explaining that.....but is it possible? Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=546307 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Are multiple Vlookup's possible?
Use the INDIRECT function
=VLookup(F1,INDIRECT(C1) ,4,FALSE) This will cause VLOOKUP to scan the table whose name or address is in C1. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Simon Lloyd" wrote in message ... Hi all, i am using this =VLOOKUP(F1,TiedEquip,4,FALSE) on my worksheet and it is located in D1, what i would like to do is a VLookup like this.....=VLookup(F1,C1 ,4,FALSE), where C1 on the same sheet would be the name of the named range to look at, this way i can have a drop down list of names which would change the contents of D1 based on the value in F1 because as i change the name in C1 it would look to a different named range! Don't know whether i was clear explaining that.....but is it possible? Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=546307 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Are multiple Vlookup's possible?
=VLookup(F1,INDIRECT(C1) ,4,FALSE)
should be what you need -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Simon Lloyd" wrote in message ... Hi all, i am using this =VLOOKUP(F1,TiedEquip,4,FALSE) on my worksheet and it is located in D1, what i would like to do is a VLookup like this.....=VLookup(F1,C1 ,4,FALSE), where C1 on the same sheet would be the name of the named range to look at, this way i can have a drop down list of names which would change the contents of D1 based on the value in F1 because as i change the name in C1 it would look to a different named range! Don't know whether i was clear explaining that.....but is it possible? Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=546307 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Are multiple Vlookup's possible?
Thanks to Chip and Bob.............worked well! Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=546307 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple vlookup's | Excel Worksheet Functions | |||
| Vlookup's in macros | Excel Discussion (Misc queries) | |||
| VLOOKUP's | Excel Worksheet Functions | |||
| Nested If with VLOOKUP's and AND function | Excel Worksheet Functions | |||
| Nested If with VLOOKUP's... I think! | Excel Worksheet Functions | |||
![Simon Lloyd[_738_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
