Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup and named ranges
Hi All, I have 2 cell ranges named "maindata" and "otherdata", which are used in a vlookup. Depending on the status of of the lookup value, the Table Array would have to be either "maindata" or "otherdata". I have therefore entered maindata and otherdata into the cells f1 and f2 respectively. This would avoid having to retype the Table Array, instead pointing the Table Array to either cell f1 or f2. When I try this, a N/A is returned can somebody please advise whether this is possible to do? regards G. -- chathag ------------------------------------------------------------------------ chathag's Profile: http://www.excelforum.com/member.php...o&userid=16519 View this thread: http://www.excelforum.com/showthread...hreadid=318767 |
#2
|
|||
|
|||
Hi
use INDIRECT(F2) in your VLOOKUP formula "chathag" wrote: Hi All, I have 2 cell ranges named "maindata" and "otherdata", which are used in a vlookup. Depending on the status of of the lookup value, the Table Array would have to be either "maindata" or "otherdata". I have therefore entered maindata and otherdata into the cells f1 and f2 respectively. This would avoid having to retype the Table Array, instead pointing the Table Array to either cell f1 or f2. When I try this, a N/A is returned can somebody please advise whether this is possible to do? regards G. -- chathag ------------------------------------------------------------------------ chathag's Profile: http://www.excelforum.com/member.php...o&userid=16519 View this thread: http://www.excelforum.com/showthread...hreadid=318767 |
#3
|
|||
|
|||
Thanks for that, but how would i implement the INDIRECT function into the VLOOKUP. -- chathag ------------------------------------------------------------------------ chathag's Profile: http://www.excelforum.com/member.php...o&userid=16519 View this thread: http://www.excelforum.com/showthread...hreadid=318767 |
#4
|
|||
|
|||
Hi
=VLOOKUP(lookup_value,INDIRECT(F2),2,0) for example -- Regards Frank Kabel Frankfurt, Germany "chathag" schrieb im Newsbeitrag ... Thanks for that, but how would i implement the INDIRECT function into the VLOOKUP. -- chathag --------------------------------------------------------------------- --- chathag's Profile: http://www.excelforum.com/member.php...o&userid=16519 View this thread: http://www.excelforum.com/showthread...hreadid=318767 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup and named ranges | Excel Worksheet Functions | |||
VLOOKUP and AND function | Excel Worksheet Functions | |||
Excel 2003 - referenceing the active worksheet page in vlookup | Excel Worksheet Functions | |||
vlookup | Excel Worksheet Functions |