Forum Discussion
Welcome To Excel Space!!
You Can Discuss Any Type Of Discussion. Here, Everyone Can Do Any Type Of Excel(or any microsoft app related) Discussions Here. Enjoy!!😊
Hi! I have an excel question. I have a workbook that has several sheets. My main sheet(sheet 1) is what I’m trying to place a formula in. I want cells in column B to auto fill with data from sheet 2 IF column A in sheet 1 matches column A in sheet 2. However, it’s possible that there are more than one matching column A.
so column A has contract numbers in sheet 1.
Sheet 2 has
column A - contract numbers
Column B - contract types
it is possible that one contract can hVe 2 different type so I want both types to auto fill on sheet 1