'Excel XLookup with queried SQL data on another sheet
I am trying to create a purchase order in excel that pulls information from an Azure SQL Database.
I have performed a query and downloaded the data from the SQL database to another sheet. I want the user to punch in a PO# and then have the data fields automatically fill out with the relevant information.
I am trying to use Xlookup to pull this information out of the data sheet but I am getting an error.
Where have I gone wrong here?
=XLOOKUP(E3,TBL_P_Purchasing!D2:D1001,TBL_P_Purchasing!B2:B1001,"error")
Solution 1:[1]
The issue is with the PO# data type. PO# is formatted as text but it should be integer.
Please change it and this should work fine.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | UtkarshPal-MT |