Log In
Register
Home
Active Member
September 11, 2019
Offline
Hi All,
Can someone help me with my problem, Currently I'm trying to improved our sizing data (kindly look on my attached file). I think it involves Vlookup and Match. I already watched many videos with this kind of command but still I fail.
For example, if you're looking on the table on the attached file,
If I input the Length =400 ft and I have a total Gas volume = 4000 CFH , It will automatically look for the Pipe size = 5
See Answer
October 5, 2010
Offline
Hi Nicko,
No file is attached.
Regards
Phil
Active Member
September 11, 2019
Offline
Sorry my attachment went wrong, Kindly see on this post my attachment.
Thanks,
Answers Post
VIP
Trusted Members
June 25, 2016
Offline
Hi Nicko
My formula is a bit long but should be able to get what you wanted.
In cell C13 enter :
=INDEX(2:2,MATCH(C12,INDIRECT("B"&MATCH(C11,A:A,0)&":"&"O"&MATCH(C11,A:A,0)),-1)+1)
Hope this helps.
Sunny
Active Member
September 11, 2019
Offline
Hi Sunny,
Thank you so much, it works 🙂 Im still studying on how you do it.
Really Appreciate 🙂
Nicko
December 5, 2016
Offline
LOVE TO SEE YOU BACK SUNNY.
Trusted Members
Moderators
November 1, 2018
Online
FWIW, you could simplify a little to:
=INDEX(2:2,MATCH(C12,INDEX($B$3:$O$8,MATCH(C11,A:A,0),0),-1)+1)
thereby also avoiding a volatile INDIRECT function.
1 Guest(s)
