#### maratonomak

##### New Member

- Joined
- May 26, 2015

- Messages
- 14

=IF(And(B1="Virginia",VLOOKUP(A2,Male!A2:C52,2),IF(A1="Male",VLOOKUP(A2,Male!A2:C52,2,FALSE),VLOOKUP(A2,Male!A1:C52,3,FALSE)).

Basically trying to get the price based on sex and age , which works with: IF(A1="Male",VLOOKUP(A2,Male!A2:C52,2,FALSE),VLOOKUP(A2,Male!A1:C52,3,FALSE)).

But I need a separate IF to look at another cell as well: IF(B1="Virginia",VLOOKUP(A2,Male!A2:C52,2). So, if B1="Virginia" the value should be Male!A2:C52.

Any help will be appreciated !!