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,FALSE),"NONE")
Your help would be appreciated.
- Thanks! Only change I had to make was converting from a General date to a normal/short date.
3 Replies
=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.
