Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Nesting VLOOKUP and HLOOKUP (HOW TO DO IT???)

Status
Not open for further replies.
Box

Box

Mechanical
Mar 11, 2002
6
Back in the day, I used to be a Q-Pro wiz. I knew how to do it all. Then windows replaced dos, and Excel replaced Quattro Pro. Now I need to perform one of those old tricks, but I can't get the syntax just right, and maybe someone can help me.

I want to nest an HLOOKUP inside a VLOOKUP. I could do it in Q-Pro. My Q-Pro routine used to look down the first column of a list, and find a value that was <= a thread diameter. Then the HLOOKup would look across that particular row, and find the corresponding thread pitch range. This calculated a tolerance for a particular thread.

Thank you for any help you can give,
GB M.E.
 
Replies continue below

Recommended for you

Sort by date Sort by votes
I use Quattro daily and, franky, find it much easier that Excel, but, hey! MS has the pull.

Try putting your Hlookup value independently as a cell result and use the Vlookup to reference that cell value.

Hope it works for you.
There are some newer commands available like INDEX which isn't quite the same but might be OK depending on your logic sequences.
 
Upvote 0 Downvote
Thank you,

Hadn't thought of that. I know it will work. But I'm still going to try to figure the syntax to get it all in one. It's one of those problems that I have to see solved. Being an engineer, I'm sure you understand.

Thanks again,
Gary
 
Upvote 0 Downvote
Just had a look at my Excel app.

The difference between Quattro and Excel seems to be the row reference. In Quattro you can use row 0 to represent the reference row. In Excel that's row 1. Also (looking up alphas in the horizontal, I need an intermediate row underneath with a number in it to count the columns
so my formula is still
+vlookup(ref,(block A3,c10),(hlookup(alpha ref,(block A1,c10),2))

Does this work for you?
 
Upvote 0 Downvote
I'll try it. I'll post the results.

Thanks for the help
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bojoka4052
  • Locked
  • Question
How to use the date I have, delete it, and replace it with next set of data? [Excel] 1
Replies
14
Views
552
bojoka4052
bojoka4052
Denial
  • Locked
  • Question
Early alternative to ISFORMULA() function 1
2
Replies
20
Views
2K
3DDave
3DDave
rb1957
  • Locked
  • Question
opening links (to other workbooks) ? 1
Replies
19
Views
1K
IRstuff
IRstuff
3DDave
  • Locked
  • Question
Only 30 years to fix this
Replies
5
Views
800
SkipVought
SkipVought
skeletron
  • Locked
  • Question
Footers and Page Break boundaries with print-to-PDF
Replies
3
Views
290
3DDave
3DDave

Part and Inventory Search

Sponsor

Back
Top Bottom