Pulling information from another sheet

Copper Contributor

I haven't used "IF" in years... Here is what I need, but not sure how to make the formula..

=IF(C2='Purchase Order'!A2:A50,Jobs!B2:B50)

 

I need C4 to populate with information from the Job sheet when a "job" is selected from the dropdown menu in C2.

 

Any help would be greatly appreciated.

3 Replies

@MrsJLG615 

=VLOOKUP(C2,CHOOSE({1,2},$A$2:$A$50,Jobs!$B$2:$B$50),2,0)

Is this what you are looking for? 

Gonna try.... Thank you!
When I change the drop down in C2 it isn't changing the address in C4 to match the info listed in the Jobs sheet column b....
But that looks very close!!!