![]() |
#1
|
|||
|
|||
![]()
Can anyone help here, I am trying to lookup a value which is in one of 6 tables all of the same format but although I can look up the name of the table to look at it gets enclosed in quotes so that I get a #VALUE! error when it is embedded in the second vlookup.
=VLOOKUP(1,VLOOKUP(key,contextlook,3,FALSE),2,FALS E) Table contextlook looks like Key 1,value 1, value 2 key 2,value 1, value 2 All of the tables that may be value 2 then look 1, value a, value b, value c 2, value d, value e, value f As you can see the idea being to extract initially value a from the relevant table found by the first vlookup VLOOKUP(key,contextlook,3,FALSE) which gives the result "value 2" - because of the quotes the second vlookup errors! How do I get this resolved? I have tried using different methods where the value is a name and a cell range neither work! |
![]() |
Tags |
nested, variable tables, vlookup |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
giocarmine | Word | 1 | 01-22-2012 11:19 AM |
issue in nested user control | selva | Misc | 1 | 10-20-2011 10:18 PM |
![]() |
JimS378 | Excel | 7 | 05-03-2011 08:20 PM |
![]() |
goodhope | Excel | 1 | 03-26-2011 10:29 AM |
Help with nested cylinders and labels | pixmanlajunta | PowerPoint | 0 | 01-18-2010 11:25 AM |