Oct 15 2021 11:30 PM - edited Oct 16 2021 01:59 PM
After I refresh my database Query 1 table, I try to lookup the slic column in Table2 to get the description in Table3. However, Only one of the descriptions is coming back. Any ideas? To be more exact, why am I getting #N/A in column F?
I thought I could use ISNUMBER and NUMBERVALUE but it works in one case but not the other???
Oct 16 2021 12:58 AM
@rodsan724 Most likely the 10, 20 and 30 are not the same type in both tables. One could be text and the other a number. Or if they are text in both tables, one could have one or more trailing spaces. Hence, #N/A as VLOOKUP doesn't find an exact match.
Oct 16 2021 08:20 AM - edited Oct 16 2021 08:21 AM
I attached the file to OP. I wasn't sure if I should l leave the data source so I deleted it. I can put back in if you like, I wasn't sure if the values would come in without the data source. I have control over Table3 but not the data source.
Oct 16 2021 08:50 AM
@rodsan724 Can't really tell where it went wrong, but some the data types were not in sync. I made it all Text and redid the VLOOKUP. Now it seems to work as expected. See attached.
Oct 16 2021 09:04 AM
Oct 16 2021 10:00 AM
Oct 16 2021 01:55 PM
Oct 16 2021 04:59 PM
SolutionOct 16 2021 04:59 PM
Solution