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

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

+1

VotesIt’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

Brenda Wilson- August 31, 2018 |

+5

VotesVLOOKUP 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 |