VLOOOKUP Please help

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi I have this formula

=-(D18-(VLOOKUP(C18,'Data Table'!$B3:$G12,5,0)))*(VLOOKUP(C18,'Data
Table'!$B3:$G12,3,0)*E18/1000)/((VLOOKUP(C18,'Data Table'!
$B3:$G12,3,0)*E18/1000)*(VLOOKUP(C18,'Data Table'!$B3:$G12,5,0)))

but when i try copying down a sheet the data table references keep
changing as I copy. How can I keep them the same?

Thanks

Brian
 
Hi I have this formula

=-(D18-(VLOOKUP(C18,'Data Table'!$B3:$G12,5,0)))*(VLOOKUP(C18,'Data
Table'!$B3:$G12,3,0)*E18/1000)/((VLOOKUP(C18,'Data Table'!
$B3:$G12,3,0)*E18/1000)*(VLOOKUP(C18,'Data Table'!$B3:$G12,5,0)))

but when i try copying down a sheet the data table references keep
changing as I copy. How can I keep them the same?

Thanks

Brian
Click to expand...

excellent, cheers
 
Back
Top