Lookup Multiple Tables
I use the following formula to look up information in a table on the Table sheet and display the resultant unit weight on the Appurtenance sheet. =IF($C16,OFFSET(PipeField,MATCH($D16,PipeSizes,0),MATCH($E16,PipeSchedule,0))*$G16*$D$3,""). My problem is there are...