Reply to thread

Message: [QUOTE="RMG1999, post: 14253298, member: 121490"] Why not create a single Master list of all the tanks in one tab. You will need to create a single field with a code. I can think of something like this to enter in column A one below the other: 23010001 stands for tank 2301, 1/16 of an inch 23010002 stands for tank 2301, 2/16 of an inch 23010003 stands for tank 2301, 3/16 of an inch .. and so on for the entire height of 2301 Then follow by 23020001, 23020002, 23020003, etc for the next tank, and so on. In column B, corresponding to each tank and 1/16th reference, you will put the volume. In your query spreadsheet, you will put the tank # in one cell, the 16th inch number in another cell, and you can create a vlookup formula that combines the contents of these two cells and then does a look up in the master. eg if you entered 2301 in one cell and 87 in another cell (representing 87/16 of an inch), yo could write a formula like 2301*10000+87 to create the code (23010087 which would stand for tank=2301, height=87/16 inch), then do a vlookup for this code in the master list Hope this helps [/QUOTE]