VLOOOKUP Please help

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
 
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
Click to expand...

excellent, cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOOKUP Please help 1
Excel Help to copy information from one row at a time to another sheet 1
I can't find why my formula is inconsistant - please help 7
function details show value, but display shows #n/a 2
Payment calculation 1
Very strange behaviour of VLOOKUP in Excel 2010 4
can you 2
sum vlookup results 5

Top