Forum Discussion
Using data
I have DATA in sheet 1 and DATA in sheet 2. I am trying to bring the data from the Pods column in sheet 2 that corresponds to the Comment column in sheet 1 and i can't seem to figure out the correct...
As per your sheet, use the below in the D2 cell and apply it to all D cells
=XLOOKUP(C2, Sheet2!A:A, Sheet2!B:B, "")