Thread: Do I need a power query for this one?
View Single Post
 
Old 04-10-2019, 03:29 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
I tried to solve what you asked for in your original question. In your first Example file you had more instances of the same Invoice Number (126799). That's why I posted the solution I did. You can't solve that with the INDEX/MATCH formula you have shown in #3.

If it is a problem with your SQL-query I don't think I can help you.

The reason that your formulas returns #N/A is that the "numbers" i column A in SQLSheet and DataSheet are text while the number in Combined!H1 is a real number.
Reply With Quote