Excel question - formula design

[brightshadow]

I'm trying to design a worksheet that will import data from othe
worksheets.. I'm a relative newbie with Excel formulas.

The formula that I'm getting hung up on is trying to do this:

1.) Search another worksheet (named Daily) in column A for a nam
(i.e., "John Doe") and return the full cell location of the cel
containing the name (i.e., A37)

2.) Take the result (Daily!A37) and offset 2 cells, and return th
numeric value located there (Daily!C37).

3.) Take Daily!C37's value (which is a number of seconds) and divide b
60 by 60 by 24, then display it in mm:ss.

The part that I can't seem to figure out is #1. I can use MATCH t
return 37, but I don't know how to make it return A37.. alternately, i
I could use the 37 and simply have it look in C37 (the imported dat
will always be in the same format) that would be great too.

So far, all I have working is:
=MATCH("John Doe",Daily!$A$1:$A$50,0)

-- returns 37 -- if I try to nest that inside an OFFSET function or tr
to manually add the C, it doesn't return any value at all.

Help! :

 

[AlfD]

Hi!

I think you would find VLOOKUP a better option.

If col A of sheet "Daily" contains unique values/names:


Put the following formula in B1 of your first sheet :

=vlookup(A1,'Daily'!A1:C200,3,false) (the 3 takes you from A to C)

and put John Doe in A1 of your first sheet.

Al

 

[brightshadow]

Wow, that was easy.

I tried VLOOKUP but the help file was mostly gibberish when I looked a
it -- that worked like a charm!

Thanks heaps!! :