Index/Match with ODBC table doesn't work unless I edit data and hit enter

[gjbankos]

I have an microsoft query pulling sql data via odbc back into a worksheet that I'm using for an index/match command. The problem is that it doesn't work (I get a #N/A) unless I edit the value in the sql data I am matching on (item code) and simply hit enter. Once I do that, my index/match command works. However, once I refresh, it goes back to the #N/A.


What is that fixing and how can I prevent that from happening?

 

[sgmpatnaik]

@gjbankos


Hi


can u upload a sample workbook it is better to understand


Thanks


SP

 

[gjbankos]

Try this:


https://www.dropbox.com/s/56hao9mq0jfgdr5/Master%20List.xlsx


The index/match is in column I and the table is on sheet2. You can use part # 5000 as an example.


thanks for your assistance.

 

[sgmpatnaik]

@GJBANKOS


HI


YOUR FORMULA IS WORKING AND THERE IS NO ERRORS I GOT


YOU WILL DO ONE THING CREATE ONE LIST BOX IN SHEET1 FOR ITEM CODE OF SHEET 2 USING WITH DATA VALIDATION AND CHECK IF ANY ERRORS PLEASE REFERS US AGAIN


THANKS


SP