klondike47

Posts: n/a

using vlookup - how do I match 2 spreadsheets w/o same exact numb.

I have 2 spreadsheets. 1 is my customers inventory and Year To Date sales the
other is my West Coast sales history. His spreadsheet does not have all of
the numbers my sheet has. I'm able to get the first matching number to bring
his sales history over but in vlookup the second numbers do not match so I
get a NA.

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, index, match?	Phyllis	Excel Worksheet Functions	4	December 13th 04 11:23 PM
match two spreadsheets	Socialism	Excel Worksheet Functions	1	December 10th 04 05:59 AM
Vlookup returns incorrect match	Smichaud	Excel Discussion (Misc queries)	2	November 30th 04 10:51 AM
Find a match that;s not exact	Phyllis	Excel Worksheet Functions	0	November 8th 04 08:12 PM
Vlookup, Index & Match	Phyllis	Excel Worksheet Functions	1	November 8th 04 06:11 PM

All times are GMT +1. The time now is 12:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us