Nov 07 2021 11:01 PM
Apr 22 2022 05:20 AM
Jul 22 2022 08:40 AM
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