Spreadsheet table auto populate
Hi,
I have a table that i’m entering figures into, i’d like to have the table reference a second table (ie: if i enter a value of 600, then that cell looks to the ‘master table’ and automatically takes the 600 value from that table. Is that possible ?
So when i put a figure in of say 1400 under Pressure PSI, it automatically looks to the chart on the right and populates the Torque and Estimate load cells from the chart to the right. Hope that makes sense !
Hi,I have a table that i’m entering figures into, i’d like to have the table reference a second table (ie: if i enter a value of 600, then that cell looks to the ‘master table’ and automatically takes the 600 value from that table. Is that possible ? So when i put a figure in of say 1400 under Pressure PSI, it automatically looks to the chart on the right and populates the Torque and Estimate load cells from the chart to the right. Hope that makes sense ! Read More