Forum Discussion

Copper Contributor

Jan 21, 2021

Excel 365 XLOOKUP - New User Question

Hi, I am trying to use the XLOOKUP function to retrieve duplicate values from 1 piece of criteria. The formula below is where i am at. =XLOOKUP(F2:F1500,Q2:Q309,Q2:R309,,-1) I am looking up ...

office 365

Terry_M09

Copper Contributor

Jan 21, 2021

Thanks. I am using the filter function now but i have to cut and paste down my sheet changing the criteria cell reference as i go. I need something a bit easier.mathetes

mathetes

Silver Contributor

Jan 21, 2021

Terry_M09

Is it possible to post a copy of your spreadsheet then? I think we need a bit more of an understanding of the full context here. Just make sure there's nothing confidential or private in the sheet.