need funct to match data in 3 seperate spreadsheets column 1 to v.

lucky

Posts: n/a

need funct to match data in 3 seperate spreadsheets column 1 to v.

I need to write a function in Excel to find matching data in 3 seperate
spreadsheets, column 1 so that I can view and compare the corresponding data
in column 5 of those 3 spreadsheets. I am hav9ing problems writing the
function: first phase
=VLOOKUP(Sheet1!A3:A1588,Sheet2!A:E,5,FALSE)

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
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM
How do I compare data in two different spreadsheets i.e. (column .	inspector gadget	Excel Discussion (Misc queries)	1	December 29th 04 05:40 PM
filling a forumla down a column from data across a row	Doug	Excel Worksheet Functions	2	December 9th 04 08:55 PM
Can you average data in 1 column based on a range of values in another?	kman24	Excel Worksheet Functions	2	November 17th 04 02:09 PM
getting data from 2 excel sheets automatically	pinar	Excel Worksheet Functions	0	November 9th 04 11:47 AM

All times are GMT +1. The time now is 11:49 PM.

Menu

About Us