I am extremely basic in my understanding of coding formulas for Google Sheets, so please help where you can. The formula I'd like to put together is to search a vertical range (column) of information on a sheet and if there is any data present, I'd like the cells to automatically fill with the data of from the corresponding row of another vertical range within that same sheet.
For instance, I'd like my cell to search a range on a sheet (for this we can say the sheet is called 'Data Import') of Cells
L1:L, and if there is any data present in that range, to import the data from the corresponding row of data in cells
C1:C. I am sure this needs to be some kind of IF formulate possibly using
importrange, but I am not sure how to create the string for this. Ideally, this will results in a list of data from
C1:C only if any data exists in the corresponding row for
L1:L within the "Data Import" sheet.
I hope this makes sense! I can clarify further if needed!