M
Merlin
I am creating an estimating worksheet and I would like to know the best way
to get data from my database worksheets into my detail estimate worksheet.
My thoughts were to utilize vlookup and place if I place a "1" in a certain
column, have that row of data pull into the estimate detail spreadsheet.
I tried to use Vlookup but it would not work for me =VLOOKUP(1,'Demo-CSA
Database'!C3:C5000,2,'Demo-CSA Database'!$C$3:$C$5000,false)
I know this is wrong. can someone help me figure this out? Do I have to
have matching data in my estimate spreadsheet? Is there a better function to
do this.
I want the data for items that I pick, by placing a 1 in column J to be
automatically pulled into the estimate sheet.
to get data from my database worksheets into my detail estimate worksheet.
My thoughts were to utilize vlookup and place if I place a "1" in a certain
column, have that row of data pull into the estimate detail spreadsheet.
I tried to use Vlookup but it would not work for me =VLOOKUP(1,'Demo-CSA
Database'!C3:C5000,2,'Demo-CSA Database'!$C$3:$C$5000,false)
I know this is wrong. can someone help me figure this out? Do I have to
have matching data in my estimate spreadsheet? Is there a better function to
do this.
I want the data for items that I pick, by placing a 1 in column J to be
automatically pulled into the estimate sheet.