Forum Discussion
Solved
Conversion from VLOOKUP to XLOOKUP
I am trying to convert formulas written in VLOOKUP to XLOOKUP. Data is in one table looking at another table. Example below of current formula - =IFERROR(VLOOKUP(A10,Cycle_Count_Report!B:G,6,FALS...
- Thanks! Only change I had to make was converting from a General date to a normal/short date.
=XLOOKUP(A10,Cycle_Count_Report!B:B,Cycle_Count_Report!G:G,"None")You can try this formula.
- Thanks! Only change I had to make was converting from a General date to a normal/short date.
- Thanks for the solution.