Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2014, 09:09 PM
asluder2000 asluder2000 is offline Nested Vlookup Help Windows 7 64bit Nested Vlookup Help Office 2010 64bit
Novice
Nested Vlookup Help
 
Join Date: Nov 2014
Posts: 3
asluder2000 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-14-2014, 06:35 PM
macropod's Avatar
macropod macropod is offline Nested Vlookup Help Windows 7 64bit Nested Vlookup Help Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Instead of using L11 on its own, use: INDIRECT(L11)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-14-2014, 11:00 PM
asluder2000 asluder2000 is offline Nested Vlookup Help Windows 7 64bit Nested Vlookup Help Office 2010 64bit
Novice
Nested Vlookup Help
 
Join Date: Nov 2014
Posts: 3
asluder2000 is on a distinguished road
Default

Thanks - works like a charm now
Reply With Quote
Reply

Thread Tools
Display Modes


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
Nested Vlookup Help numbered nested list giocarmine Word 1 01-22-2012 11:19 AM
Nested Vlookup Help 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft