INDEX & MATCH not working through a power query

So I have a workbook comprising of two worksheets; 'Index' and 'PriceSheet'. The table found within 'PriceSheet' comes from a Get Data from workbook Power Query (See image '1').

1.JPG

The table of info found in 'PriceSheet' is shown in image 2.

2.JPG

Both files are stored on Office365 SharePoint, though the workbook is opened and edited locally. The query connection works perfectly fine and refreshes when required.

Data types for 'PriceSheet' are as follows; Col A1:A13 = General aligned to right side // Row A1:L1 = General aligned to right side // Cells B2:L13 = Number and aligned to the right. All columns have had 'Text to Columns' performed on them.

So as you can see the formula should result in the value found at the intersection of both 'JPA5' and '250', which in this case would be '1.52', but instead i get the #N/A

I have tested this formula in steps:
First i just wrote an index formula and it worked '=INDEX(PriceSheet!A1:A13,3)'
Then i wrote an index formula that came back with a cells contents based on a position '=INDEX(PriceSheet!A1:L13,3,5)' and it worked.
Next i wrote a formula that used the match function for the rows only assigning a column number to it '=INDEX(PriceSheet!A1:L13,MATCH(B4,PriceSheet!A1:A13,0),5)' and again this worked fine.
However, the moment i add the Match function for the columns it fails.

Any thoughts and advice greatly appreciated as i am going out of my mind here!!

Hi AliGW,

Thank you for your reply, I have tried the (0 or 1) at the end with no joy, but deliberately leave it out to allow the freedom of being able to input a 'Qty' that isn't listed in the table. For example if somebody input 255 as the Qty, it would normally return the 250 rate/price and saves me having to insert columns for every quantity.

Finally, the reason i did not include an actual workbook example is in case the fact that the 'PriceSheet' worksheet was the result of a power query was the reason for my issue, as i am unsure whether or not this is affecting things??

Sample workbook attached

Whoa, what magic is this???? MATCH(B6,--(PriceSheet!B1:L1),0))

What are you doing here? It works though Is this a genuine resolve or a work around?

many thanks for your time, it is much appreciated