Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.