title: Excel data indexing and retrieval across multiple sheets
body: <p>I am trying to pull the data using a IF/Vlookup formula from other sheets. So, I have three sheets in total, two of which contain the age of men and women. The other sheet contains the names of men, women and their age. The formula should give me their age corresponding to their name (retrieved from the relevant sheets). If my data that I input is not in men or women, then it should "Not Applicable".</p>
  
  <p>I tried using the the IF OR formula with loops as well, but it appears the it does not give me a proper result.</p>
  
  <p>Appreciate any help on this!</p>
  
  <p>Thanks.</p>