Brad,

Impossible to tell for sure what you are actually doing since your seem to
use rows and columns interchangeably, but one of these formulas should give
you a starting point.

If your sales persons' names go down the column (all in the same column):
=INDEX(B:B,MATCH("Brad",A:A,FALSE)+5)
If your sales persons' names go across the row (all on the same row):
=INDEX(6:6,1,MATCH("Brad",2:2,FALSE)+1)

HTH,
Bernie
MS Excel MVP

"Brad" wrote in message
...
I have a spreadsheet that outputs with a sales person name in A1 but the
info
that I need from that name (using Vlookup) is in B6. The next sales
persons
name is in C1, info in D6 and so on. Currently I'm opening the
spreadsheet
and inserting a cell in the first row to drop A1 to B1. What I would like
is
a formula with Vlookup that will pull the info from B6 if it finds a match
in
A1. Is this possible?