Thread: Vlookup derived wrong value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michelle michelle is offline
external usenet poster
  
Posts: 310
Default Vlookup derived wrong value
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





Reply With QuoteReply With Quote