Formula/Function to find Cell information

From: Monni70 (Monni70.16ulyy_at_excelforum-nospam.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 00:36:36 -0500

Please somebody help me this complex problem.
I have two separate sheets - sheet no. 1 and sheet no. 2. (Please see
the attached .jpg file)
The *** no. 1 is filled manually i.e. Cell information is written by
user.
The problem is *** No. 2, which should have the Cells included some
sort of automatic "find" function to search correct Cell information
from *** no. 1.
The Cells B5 to D7 in *** no. 2 should have some sort of find/seach
function or formula to find correct information from the Cells B3...G5
in *** no. 1. When the correct information is find the return value
should be the one of the value from the Column A in *** no. 1 (either
"car1" or "car2" or "car3" on the .jpg file).
I.e. the Cell B5 tries to search if it finds "Yellow Car" for Week-1.

Hopely I expressed this problem enough clearly....thanks in advance for
any help! :confused:

           Attachment filename: *** no1 and no2.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=556606 

---
Message posted from http://www.ExcelForum.com/