# Can you write a formul that will put multipal answers in multipal.

=?Utf-8?B?SmlsbF8=?=
Guest
Posts: n/a

 3rd Apr 2006
I am trying to write a formuls that has a constant value (we wil call it cell
C14) that looks up that number in a different worksheet and imputs the
coresponding names associated with that number in the cells (multipal answers
to the same number). How do I write this?

=?Utf-8?B?cGRiZXJnZXI=?=
Guest
Posts: n/a

 3rd Apr 2006
Jill -- Let's say that your other sheet is named 'Other'. On that sheet,
your table of data is organized with 100 rows of data so that you compare
your cell C14 info to the info incolumn A, and you have names in columns B,
C, & D that you want to retrieve.

A
1 =VLOOKUP(c14,Other!a1:d100,2,false)
2 =VLOOKUP(C14,Other!a1:d100,3,false)
3 =VLOOKUP(C14,Other!a1:d100,4,false)

If the index info in column 'A' is in strict ascending order (either numeric
or alphabetic) then you don't need the 'false').

Hope that helps.

"Jill_" wrote:

> I am trying to write a formuls that has a constant value (we wil call it cell
> C14) that looks up that number in a different worksheet and imputs the
> coresponding names associated with that number in the cells (multipal answers
> to the same number). How do I write this?

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?VmFu?= Microsoft Excel Worksheet Functions 1 16th Aug 2007 01:46 AM =?Utf-8?B?Um9kIEJvd3llcg==?= Microsoft Excel Misc 4 14th Jul 2007 01:22 AM =?Utf-8?B?SmlsbF8=?= Microsoft Excel Worksheet Functions 0 3rd Apr 2006 10:05 PM =?Utf-8?B?c3RldmVj?= Microsoft Excel Worksheet Functions 1 8th Nov 2004 10:20 PM Alex Windows XP Messenger 0 22nd Jul 2003 09:35 AM

Features