Hi


Vhen you want to get info from some particular cell on same row with
matching parameter, you can use VLOOKUP function
=VLOOKUP(SearchValue,DatalistRange,ColumnNumber,FA LSE)
where
SearchValue is value to search for, or reference to cell with it;
DatalistRange ist the range of cells, containing table you are
searching for SearchValue. The leftmost column of DatalistRange must
contain the value you are searching for, and it must contain the
column with return value.
ColumnNumber is number of column with return value in DatalistRange

Example: You have on Sheet2 the table
Date, Index, Name, Value
with data in rows 2:100
and you want to return Value for Index=123
=VLOOKUP(123,Sheet2!B2:D100,3,FALSE)

NB! The first occurence of 123 is detected!


Arvi Laanemets


On 25 Jul 2003 09:11:40 -0700, (Josh) wrote:

I have a data list of 48000 entries of which all cells are filled and
complete. I then have another list that has 300+ entries that has 4
cells within each with missing information. I was needing to know a
way to populate these cells with either a formula or a macro to take
the corresponding/matching cells within the first list to populate the
second.

Thanks