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...
Option 1:
In D2 on Sheet1:
=XLOOKUP(C2, Sheet2!$A$2:$A$10000, Sheet2!$B$2:$B$10000, "")
and then fill down.
Option 2:
Assuming that the data on Sheet1 extend to row 250, enter the following formula in D2 on Sheet1:
=XLOOKUP(C2:C250, Sheet2!$A$2:$A$10000, Sheet2!$B$2:$B$10000, "")
This will spill to D2:D250.
when i do as you suggest, i get this error:
XLOOKUP is only available in recent versions of Excel. If you have an older version, try
=IFERROR(VLOOKUP(C2, Sheet2!$A$2:$B$10000, 2, FALSE), "")