Nov 04 2022 02:21 PM
I have copied the help example from Microsoft 365 help service and pasted it in my excel spreadsheet with the VLOOKUP and XLOOKUP formulas inserted into my spreadsheet attached as a shared file with the help explanation and my spreadsheet trying to use these functions, and can't get them to work. Please advise my miss usage.
Thanks Richard Lambhttps://1drv.ms/x/s!Avoy1y2cOvrvjcVquUtZr4812EnhLw?e=EKF4BX
Nov 04 2022 02:33 PM
The formula in L2229 is
=VLOOKUP(K2231,C5:C2315,D5:D2315)
=VLOOKUP(K2229, C5:D2315, 2, FALSE)
The formula in L2232 is
=XLOOKUP(K2, C5:C2315,D5,D315)
=XLOOKUP(K2229, C5:C2315, D5:D2315)
Nov 18 2022 06:35 AM