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.
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). I also have screenshots to share with you if that would help.
JUST PLEASE TELL ME HOW TO ENTER THIS FORMULA PROPERLY?? IT IS DRIVING ME COMPLETELY INSANE??
Bookmarks