So to clarify if I have my formula on the "Case_Form" tab in cell AH7 and I want to reference the number that is in B7 and then locate that same number on the "Demographics" tab and bring over all additional information from the row where the number is located would my formula look like this?
VLOOKUP($B7,Demographics!$A$2:E$156,COLUMN(G15),FALSE)