Posted to microsoft.public.excel.worksheet.functions

michelle

external usenet poster

Posts: 310

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup - can't figure out what's wrong	pm	Excel Worksheet Functions	5	December 15th 06 08:02 PM
Office Assistance: VLOOKUP, Example 3- Row headers 1-7 are wrong?	Skydiver	Excel Worksheet Functions	0	September 27th 06 08:44 PM
vlookup, what am I doing wrong?	ufo_pilot	Excel Discussion (Misc queries)	3	August 9th 05 05:36 PM
VLOOKUP returning wrong row	jthomas	Excel Worksheet Functions	6	August 3rd 05 10:32 PM
What wrong with VLOOKUP formula	TARZAN	Excel Worksheet Functions	2	January 31st 05 10:09 PM

All times are GMT +1. The time now is 03:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us