Vlookup derived wrong value
Excel supports wild cards (* and ?, any set of characters and any single
character).
The tilde is used to tell excel that you don't mean the wildcard--you actually
mean that character ~* and ~?.
Since tilde has a special purpose, you have to treat it special too: ~~.
And if your data has asterisks and question marks, you may want something like:
=VLOOKUP(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"~"," ~~"),"?","~?"),"*","~*"),
LastMthCost!A2:B3,2,FALSE)
Michelle wrote:
Formula used for LastMthCost is =vlookup(A2,LastMthCost!A2:B3,2,FALSE)
Instead of returning 1.5 but i got 2.5!!!!! Please help
Worksheet: ThisMthCost
A B
1 PartNum LastMthCost
2 M03541224*a 2.5
Worksheet: LastMthCost
A B
1 PartNum LastMthCost
2 M03541224**a 2.5
3 M03541224*a 1.5
--
Dave Peterson
|