Trying to get this to work

[Highworld]

Hello In no shape of form am I am expert within Excel but trying to get this to work.

But i am trying to get it so that when clicking on D16 (should be showing an Options Button) it pulls data from H19 and puts that information in C8. For some reason I am unable to get this to function correctly.

Income Calculation Worksheet Master w updated 2023 v1.xlsm
	B	C	D	E	F	G	H
4	Owner Occupied PITI	1,000.00		Loan Size	O/O & 2nd Home	NOO
5	Second Home Outstanding Lien Balance(s)
6	Second Home PITI			<$726,200	2	6
7	Bridge Loan P&I			>$726,201 to $1,000,000	6	N/A
8	Reserve Requirement for O/O (months)	0		>$1,000,000	12	N/A
9	Reserve Requirement for 2nd Home (months)	2
10	Reserve Requirement for O/O, 2nd Home, & Bridge($)	$0		FALSE
11
12	Subject NOO Outstanding Lien Balance	$0.00		TRUE
13	Subject NOO Total PITI	$0.00
14	Non-Subject NOO Outstanding Lien Balance(s)	$0.00		FALSE
15	Non-Subject NOO Total PITI	$0.00
16	Number of financed 1-4 unit residential properties			FALSE
17	Reserve Requirement for Subject NOO ($)	$0
18	Reserve Requirement for Non-Subject NOO ($)	$0		Property Type	Max LTV	Max Loan AMT	Reserve
19	Total Assets Required by DU
20	Additional Required Reserves
Reserves & DTI

Cell Formulas
Range	Formula
C8	C8	=IF($K$1<>1,0,IF(AND($E$14=TRUE,$K$1=1,$C$3>726201,$C$3<=1000000),$F$7,IF(AND($E$14=TRUE,$K$1=1,$C$3>1000000),$F$8,IF($C$16<=4,VLOOKUP(1,ReserveReq,3),IF($C$16>=5,VLOOKUP(1,ReserveReq,4),0)))))
C9	C9	=IF($K$1<>2,0,IF(AND($E$14=TRUE,$K$1=2,$C$5>650000,$C$5<=1000000),$F$7,IF(AND($E$14=TRUE,$K$1=2,$C$5>1000000),$F$8,IF($C$16<=4,VLOOKUP(2,ReserveReq,3),IF($C$16>=5,VLOOKUP(2,ReserveReq,4),0)))))
C10	C10	=(C4*C8)+(C6*C9)+(C7*6)
C13	C13	=IF('Net Rent'!$B$2=TRUE,'Net Rent'!B19,0)
C15	C15	=IF('Net Rent'!B2=TRUE,SUM('Net Rent'!F19:G19,'Net Rent'!F38:G38,'Net Rent'!B38:C38,'Net Rent'!B57:C57,'Net Rent'!F57:G57,'Net Rent'!F76:G76,'Net Rent'!B76:C76,'Net Rent 2'!B19:C19,'Net Rent 2'!F19:G19,'Net Rent 2'!F38:G38,'Net Rent 2'!B38:C38,'Net Rent 2'!B57:C57,'Net Rent 2'!F57:G57,'Net Rent 2'!F76:G76,'Net Rent 2'!B76:C76,'Net Rent 3'!B19:C19,'Net Rent 3'!F19:G19,'Net Rent 3'!F38:G38,'Net Rent 3'!B38:C38,'Net Rent 3'!B57:C57,'Net Rent 3'!F57:G57,'Net Rent 3'!F76:G76,'Net Rent 3'!B76:C76,),SUM('Net Rent'!B19:C19,'Net Rent'!F19:G19,'Net Rent'!F38:G38,'Net Rent'!B38:C38,'Net Rent'!B57:C57,'Net Rent'!F57:G57,'Net Rent'!F76:G76,'Net Rent'!B76:C76,'Net Rent 2'!B19:C19,'Net Rent 2'!F19:G19,'Net Rent 2'!F38:G38,'Net Rent 2'!B38:C38,'Net Rent 2'!B57:C57,'Net Rent 2'!F57:G57,'Net Rent 2'!F76:G76,'Net Rent 2'!B76:C76,'Net Rent 3'!B19:C19,'Net Rent 3'!F19:G19,'Net Rent 3'!F38:G38,'Net Rent 3'!B38:C38,'Net Rent 3'!B57:C57,'Net Rent 3'!F57:G57,'Net Rent 3'!F76:G76,'Net Rent 3'!B76:C76,))
C17	C17	=(($C$13)*(VLOOKUP(3,ReserveReq,3)))
C18	C18	=IF(D5=TRUE,0)*($C$15*IF($C$16<=4,VLOOKUP(1,ReserveReq,3),IF($C$16>=5,(VLOOKUP(5,ReserveReq,4)))))

Named Ranges
Name	Refers To	Cells
ReserveReq	='Reserves & DTI'!$K$3:$N$7	C8:C9, C17:C18

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E18:H19	Expression	=$E$16="false"	text	NO
E17:H20	Expression	=E16="False"	text	NO
B19:C19	Expression	=IF($E$10=FALSE,TRUE,FALSE)	text	NO

Cells with Data Validation
Cell	Allow	Criteria
E19	List	=$L$26:$N$26
F19	List	=$T$11#
G19	List	=$U$11#
H19	List	=$V$11#

 

[awoohaw]

My Pleasure.
If you thing a post has provided you with an answer please mark that post as the answer