Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have searched and tried various solutions elsewhere but none seems to work for both conditions. I would like to have the formula:

=IF($A2="Elementary", VLOOKUP($B2,'ELEM PRINCIPAL'!$B:$AA,7,false), VLOOKUP($B2,'HS PRINCIPAL'!$B:$AA,7,false))

inserted as new rows are added to my spreadsheet. That is all simple I hope. Thanks.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.