Excel Magic Trick 643: IF Function to Pull Data From A Different Column
Download Files:
https://people.highline.edu/mgirvin/Y...
See how to create an IF function formula that will pull data from column C based on criteria in column B. See how to join cell content to get a dynamic data set label using the Ampersand Join symbol.