=match problem

[mrclox]

If I put a formula into cell B1 suchas this =match("name",A:A,0) how can i then put the contents of the cell containing "name" and cells next to it into cell D1, E1, F1

Thanks in advance for any help

 

[nbrcrunch]

Your post slightly confused me so let me setup an example:

In cells A1 through A5 I have:
bob
carl
george
rick
danny

(Yes, I purposely put danny out of alpha order.)

In cell B1 I have:
=MATCH("danny",A1:A5,0)
which returns 5 (row 5)

In cell C1 I have:
=INDEX(A1:A5,B1,1)
which returns "danny"

However, for this simple project, VLOOKUP is much easier to use.

(I do not understand what columns D, E & F were supposed to contain.)