|
|
#6
04-10-2019, 03:29 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Issues Using Power Query file in Excel 2016 and then in 2013 | bld9936 | Excel Programming | 0 | 02-27-2017 12:50 PM |
| Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
| can power point LINK to embedded object in power point ? | johnseito | PowerPoint | 0 | 05-24-2014 04:31 AM |
| How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |
| Microsoft Power Point 2004 to Office Power Point 2007 | chuff | PowerPoint | 0 | 03-20-2011 01:23 PM |
Windows 10 
Office 2016
Threaded Mode