Okay, lets see if I can expand and change this question a bit....

I figured out how to mix text and a formula within a cell. Awesome. I also figured that since the column with GENDER is the same, and only the row changes I was able to use row() to define the cell I need.

New problem... And I am sure there is a solution, just trying to locate it. This might turn into more of a working log than anything

My cell with the variables for my drop down list is in sheet 2. My data in sheet 1. Sheet 1 is also where the drop down list is. When I drop down and select my variable, it evaluates it, but gives me the row of the original variable in sheet 2. Is there a way to have the function re-evaluated once it's selected on sheet 1? Or perhaps a function that pulls from sheet 1? Thoughts?