Find values in two columns then highlighted cells

[Rocky2013]

Hello,
I am looking for VBA to find the value (200) in A2:F15, The lookup value should be in between
A1:B15, A2:A15 or B2:B15. Once the lookup (200) is defined its location, then next lookup the
result (21) in one of five columns based on the your status in K5 (MFJ). The row no. for the
result has the same row no. as the first lookup value (200).

Fill 2 cells for the lookup values (A12 and B12), and the result in D12 in light blue R: 197, G: 217
and B: 241.


Thanks for the help.

[myou]

Maybe you could use Conditional Formatting?

[protonLeah]

named ranges:
AtLeast=Sheet1!$A$1:$A$15
hoh=Sheet1!$F$1:$F$15
LessThan=Sheet1!$B$1:$B$15
mfs=Sheet1!$E$1:$E$15
mjf =Sheet1!$D$1:$D$15
Single=Sheet1!$C$1:$C$15
N6:

Please Login or Register  to view this content.

N9:

Please Login or Register  to view this content.

O9:

Please Login or Register  to view this content.

conditional format columns
a:b

Please Login or Register  to view this content.

c - f:

Please Login or Register  to view this content.

[Rocky2013]

Hi protonLeah, It works well without using VBA.

Hi myou, Thanks for suggestion.

[protonLeah]

Your're welcome