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...
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), "")