Posted to microsoft.public.excel.worksheet.functions

akee

Posts: n/a

vlookup formula not working with data on separate sheet

I have a sheet set up with names. I have 2 other sheets with spouses and
children that belong to the first sheet. I want to insert a formula that
will look up the correct spouse (based on a member number) and put in it the
column. Same with the children. I tried the vlookup function, but it did
not return the correct result. Any suggestions on the best formula? Thank
you.

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
combo box from data validation with source list in separate sheet	Jay Trull	Excel Worksheet Functions	6	March 7th 06 01:59 AM
Importing Data	Jillian	Excel Worksheet Functions	9	December 23rd 05 12:45 PM
Help PLEASE! Not sure what answer is: Match? Index? Other?	baz	Excel Worksheet Functions	7	September 3rd 05 03:47 PM
Multiple worksheet queries	liam	Excel Worksheet Functions	3	February 16th 05 06:52 PM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us