Nested IF and LOOKUP functions (edit 1)

rsw8679 · Mar 25th, 2002, 04:27 PM

I would like to retrieve information on pipe lengths from Table 2 and insert them into Table 1.
Table 1 has the pump station number and year of installation in a row, and the pipe diameters in columns. The length needs to be put in the appropriate row under the appropriate column heading.
Table 2 holds information from a RIS dump of the GIS data. Pump Station, year, diameter, and length are all in columns. I have an ascending sort by pump station and year.
No 2 pump stations are alike, some have only one year and one diameter while the worst case has 3 years and 2 diameters.
Can you please help me figure this out, I have multiple problems with syntax.
Thanks in advance Randy

[ This Message was edited by: rsw8679 on 2002-03-26 07:24 ]

Anne Troy · Mar 25th, 2002, 07:12 PM

Randy, your data and explanation are very hard to understand. If you try to give a better explanation of what you are trying to do, I'd appreciate it. Maybe others will understand, but as soon as a question starts dropping to the bottom of the page unanswered, I get concerned--especially if I don't understand it, because maybe no one else did either.

If you really cannot explain it better, perhaps you should offer to send the file to someone.

Mar 25th, 2002, 07:12 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Randy, your data and explanation are very hard to understand. If you try to give a better explanation of what you are trying to do, I'd appreciate it. Maybe others will understand, but as soon as a question starts dropping to the bottom of the page unanswered, I get concerned--especially if I don't understand it, because maybe no one else did either. If you really cannot explain it better, perhaps you should offer to send the file to someone. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 04:27 PM	#1
rsw8679 New Member Join Date: Mar 2002 Posts: 5	I would like to retrieve information on pipe lengths from Table 2 and insert them into Table 1. Table 1 has the pump station number and year of installation in a row, and the pipe diameters in columns. The length needs to be put in the appropriate row under the appropriate column heading. Table 2 holds information from a RIS dump of the GIS data. Pump Station, year, diameter, and length are all in columns. I have an ascending sort by pump station and year. No 2 pump stations are alike, some have only one year and one diameter while the worst case has 3 years and 2 diameters. Can you please help me figure this out, I have multiple problems with syntax. Thanks in advance Randy [ This Message was edited by: rsw8679 on 2002-03-26 07:24 ]