Feb 15 2022 09:09 AM
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.
Feb 15 2022 09:53 AM
=VLOOKUP(C2,CHOOSE({1,2},$A$2:$A$50,Jobs!$B$2:$B$50),2,0)
Is this what you are looking for?
Feb 15 2022 10:02 AM