Look up a value in another sheet

[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.

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??

[6StringJazzer]

Your screen shots were not attached correctly.

I would suggest attaching your actual file. See yellow banner at the top of the page.

Your sample VLOOKUP formula is wrong. Please look up the Excel help for VLOOKUP. The second argument needs to be a range, not a single cell.

Also your title needs work. I tweaked it a bit because you are still a new user but please give thought to titles.

[alexanderbouraad]

I've tried countless times to attach screenshots on here. They never attach. EVER. I upload the image and nothing ever happens. It just sits there doing nothing. It never processes the image or saves it or anything. So I just gave up trying to attach screenshots on here.