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?