i,
Im familiar with SQL queries and so Im thinking I should be able to achieve a query within Excel - am I right ????

What I would like to do is - I have a sheet which imports data from an external source and data extracted from another source - both of which could contain multiple invoice numbers. I would like to be able to show those complete orders on a 3rd sheet based on the order number within the cell. I have attached an example which shows DataA (which would be the SQL data) DataB another source of data and then combined data which has the invoice number atthe top and then would pull through from the other 2 worksheets the data.
Thanks

Attached Files

Example.xlsx (10.8 KB, 10 views)

Is it like shown in the attached?

Attached Files

InvoiceNumber.xlsx (18.3 KB, 6 views)

Thanks Xor I went about it a different way but am not quite there - it didn't help that my example didn't have the correct\matching columns for the 2 data extracts so I apologise about that.

I think I can get away with an INDEX & MATCH which as on my new attached example is working for the data which is manually entered into Data2 but doesn't work for the data which is a link to an SQL table\stored procedure.

Thanks

Attached Files

Example.xlsx (10.6 KB, 5 views)

Does that mean that you don't need any further help?

Sorry - I would like help if that's ok? As my Index and Match doesn't work for the data which is linked to the sheet via a data connection to an SQL server but does work for data that's typed into the 2nd spread sheet and I cant work out the reason?

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.