Welcome Guest.

2Answers

Why is my VLOOKUP value not accurately showing Table 2 The data cannot be exported   Figure 1 is the error  Figure 2 is correct

Asked by: Peter Green 188 views IT August 31, 2018

Why is my VLOOKUP value not accurately showing Table 2 The data cannot be exported   Figure 1 is the error  Figure 2 is correct

2 Answers

  1. +1Votes  

    It’s hard to judge your situation:

           Your formula is not properly described, your image is not fully displayed

    But the formula you have set already shows some data, indicating that your formula should not have big errors

    According to experience, most Yes, you have not set the query area as an absolute reference, and you have not set an exact search

              For example: =VLOOKUP(D3, ‘Table 2’!B1: C2000,2)

                         This formula sets the fuzzy lookup, so the search results may be incorrect

                          There is no absolute reference to the search area. When the formula is pulled down, the reference area will change

    So it should be changed to:

              =VLOOKUP(D3, ‘Table 2’!$B$1:$C$2000,2,FALSE)

     You can

    Question: So how should I change it to find it accurately

    Ans Wer: =VLOOKUP(D3, ‘Table 2’!$B$1:$C$2000,2,FALSE)
    The last parameter of this formula is false to indicate exact search.
       If there are really fewer final parameters or tures, it means that the fuzzy search

    Brenda Wilson- August 31, 2018 |

  2. +5Votes  

    VLOOKUP function’s fourth parameter omitting is fuzzy search, not exact search.
    Adding an English comma after 2 is an exact search.

    Joyce- August 31, 2018 |