return values of particular cells

[Kranor]

hello all thanks for previous help I now have another problem.

I have a sheet of data that is my source data. I have another shee
which is compiled data. what I need to do is from the compiled Sheet
data, search the source sheet for a matching row of data once found
need to return the data from the last two cells from the found row o
the source data sheet to two cells on the end of the row for th
matching data on the compiled sheet. Hmm if you ca
understand what I need then you are better than I am. As always an
help greatly appreciated. ;

 

[dave]

seems to require a vlookup formula.

Vlookup on the data which will have a match in the source
data tab, making sure your range on which you lookup
covers your source data completely, with the first column
being the column which contains the matching data.

If the data you'd like to return is to the left of the
matching criteria column, you must either rearrange your
columns, so the matching data column is the first column
Other options (like an array formula)are slightly more
complicated but necessary if you can not reorder your
columns.

For example,

If you had

[1] [2] [3]
name date amount [A]
me 1/1/01 5
you 2/1/01 10 [C]
them 3/1/01 15 [D]

and your compiled tab has the 1/1/01 which is your
matching criteria, and you'd like to lookup the name, its
easiest to simply reorder your columns to 2 first, 1
second and 3 third before you use vlookup.


Lets assume you didnt have to reorder and you had the name
in your compiled sheet, and wanted to lookup the amount.
The formula would be...
Vlookup([link to name in compiled tab - let's say A1],
A13,3,0)

hth,
Dave


If not, an array formula or sumif, countif might apply.