PLEASE HELP!!! Can Not Get Formulas To Work??

[AlexanderBouraad]

I need to know what the VLOOKUP FORMULA is for moving numbers between these 2 sheets because I can not figure out the formula myself. I have tried all day, and I can not get it.

JUST LIKE IT SHOWS IN THE SCREENSHOT ABOVE. I have 2 sheets named "Testing Day 1" and "Month 1 Week 1". I want to pull the number in cell Q12 from "Testing Day 1" and then drop that number into the cell B97 in "Month 1 Week 1".

I know I need to enter a VLOOKUP FORMULA (or another formula that does the same thing) into the cell B97 in Month 1 Week 1. But I don't know exactly how to enter all the variables in the formula to make it work. I do know the formula needs to look something like this though.

=VLOOKUP(Q12, Testing Day 1!$B$97, 14, FALSE)

I want to do the exact same thing in the screenshot below too. Pull the number from cell Q12 in Testing Day 1 and drop that number into cell C11 in Master File using a VLOOKUP FORMULA again (or another formula that does the same thing).

JUST PLEASE TELL ME HOW TO ENTER THIS FORMULA PROPERLY?? IT IS DRIVING ME COMPLETELY INSANE??

 

[kweaver]

Welcome to Mr. Excel,

If it were a VLOOKUP, you (a) need to have single quotes around the sheet name because of the spaces and (b) you need to be looking in a range's first column.
If you simply want the value from one to the other, write in B97: =' Testing Day 1'!Q12

BTW: it would help greatly if you didn't use screen shots but use XL2BB so that in trying to replicate your issue(s) we don't have to actually type the data.