#1
|
|||
|
|||
Nested Vlookup Help
I am using the vlookup in my workbook to lookup info in a table I have created and named using the name manager. Currently the formula I am using is as follows:
=IF(H11<>0,IF(H11<>"",VLOOKUP(H11,sstubalbr,VLOOKU P(O11,coln,2)),""),"") Col H gives the size Col O gives the item code/type (pipe, elbow, etc) sstubalbr is the labor table I have defined Both lookups work independtly. I have added a new column L that i have called Labor Table. I would like to use this as the input for the labor table instead of hard coding like I have in example above. when I substitute the cell reference "L1" (ie) in place of the "sstubalbr" I get "#N/A" instead of the value I am trying to fetch from the labor table. I have also defined a list/table called "Labor_Table_List" that i have tried using in place of the hard coded labor table name. So that the formula above now looks like this: =IF(H11<>0,IF(H11<>"",VLOOKUP(H11,vlookup(L11,Labo r_Table_List,1),VLOOKUP(O11,coln,2)),""),"") This gives a "#Value" error. Any suggestions? This may not be the best way to do it. I am trying to allow other users to input the labor table into col "L" so they don't have to edit the lookup formula I have attached my spreadsheet. The tabs named "System *" are the ones with the formula in it in Col "s" 2014 Mechanical Bid Form.xlsm |
#2
|
||||
|
||||
Instead of using L11 on its own, use: INDIRECT(L11)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks - works like a charm now
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to setup Nested If statement | bigukfan | Mail Merge | 4 | 04-30-2014 05:19 AM |
Nested vlookup with varable tables! | Dave Jones | Excel | 0 | 08-30-2012 09:15 AM |
numbered nested list | giocarmine | Word | 1 | 01-22-2012 11:19 AM |
Nested IFs | JimS378 | Excel | 7 | 05-03-2011 08:20 PM |
Help with nested cylinders and labels | pixmanlajunta | PowerPoint | 0 | 01-18-2010 11:25 AM |