Forum Discussion
steve_vicknair
Jun 16, 2022Copper Contributor
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...
- Jun 16, 2022Thanks! Only change I had to make was converting from a General date to a normal/short date.
steve_vicknair
Jun 16, 2022Copper Contributor
Thanks! Only change I had to make was converting from a General date to a normal/short date.
steve_vicknair
Jun 22, 2022Copper Contributor
Thanks for the solution.