Forum Discussion
find same value 2 worksheets and populate value from different column
Hi All, So this is probably super basic but I have tried a VLOOKUP and IF formula and not getting anywhere. Basically I'm trying to match a value in different worksheets and get different c...
If you have Microsoft 365 or Office 2021:
=XLOOKUP(B2,'Worksheet2'!D:D,'Worksheet2'!C:C,"")
If you have an older version:
=IFERROR(INDEX('Worksheet2'!C:C,MATCH(B2,'Worksheet2'!D:D,0)),"")
Replace Worksheet2 with the real name of the sheet with the data to look up,then fill down.