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
Hi Nicko,
No file is attached.
Regards
Phil
Sorry my attachment went wrong, Kindly see on this post my attachment.
Thanks,
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
Hi Sunny,
Thank you so much, it works 🙂 Im still studying on how you do it.
Really Appreciate 🙂
Nicko
LOVE TO SEE YOU BACK SUNNY.
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.
Thanks Velouria and David.
