Forum Discussion
rodsan724
Oct 16, 2021Brass Contributor
Why isn't my vlookup returning most of the values?
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 exac...
- Oct 16, 2021Figured it out!
=VLOOKUP(IF(ISNUMBER(VALUE(D2)),NUMBERVALUE(D2),D2),Table3,2,FALSE)
VLOOKUP
ISNUMBER
VALUE
NUMBERVALUE
rodsan724
Oct 16, 2021Brass Contributor
Figured it out!
=VLOOKUP(IF(ISNUMBER(VALUE(D2)),NUMBERVALUE(D2),D2),Table3,2,FALSE)
VLOOKUP
ISNUMBER
VALUE
NUMBERVALUE
=VLOOKUP(IF(ISNUMBER(VALUE(D2)),NUMBERVALUE(D2),D2),Table3,2,FALSE)
VLOOKUP
ISNUMBER
VALUE
NUMBERVALUE