This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to extract a serial number based on a two locations.
I have another sheet that I can extract and am hoping to extract it in order to update every once in a while.
Here is the formula I am trying.
=XLOOKUP((('Inventory'!I6:I1040="A5")*('Inventory'!D6:D1040="B3")),'Inventory'!A6:I1040,'Inventory'!G6:G1040)
For the first Cell I am trying to check for A5 and B3 in another sheet (Inventory)
It is giving a #Value error and I cannot find where I am going wrong
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
The article also contains a link to a macro that you can use to anonymize your data.
Andreas.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 92%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
What I can gather from your formula is that you are looking in the Inventory sheet to get a result from Column G. You have the Lookup Array as Column A, but your Lookup Value and Lookup Array are a problem.
Your Lookup Value in the formula is using a multiplication logic which produces either 1 or 0 which I am sure is not what you have in Column A of the Inventory sheet. Here are two guesses at how to write the formula, but without seeing the data layout in your Inventory sheet it is just a guess.
Here is my guess at a sample Inventory sheet.
If you are trying to get the result from Column G if Column I matches A5 and Column D matches B3, use this formula entered below in B5.
=XLOOKUP(1,(Inventory!I6:I1040=A5)*(Inventory!D6:D1040=B3),Inventory!G6:G1040)
If you are trying to combine the data in A5 and B3 to look that up in Column A, use this formula shown in B5 below.
=XLOOKUP(A5&B3,Inventory!A6:A1040,Inventory!G6:G1040)
If this is not sufficient to solve your issue, please reply with more detail and paste in data that can be copied into Excel with any sensitive data removed.
This solved my issue thanks!!
=XLOOKUP(1,(Inventory!I6:I1040=A5)*(Inventory!D6:D1040=B3),Inventory!G6:G1040)
This was what I was looking for thanks.