6214: CAMERON PAYNE 11,325 17 13,852 5,578.82 4,281.90 1,296.91 23.25 2,129.75 2,152.16 50.26 215.22
6206: STEVE FLEMING 21 24 100 13,706.65 11,893.96 1,812.69 13.22 9,943.28 1,950.68 16.40 195.07
6227: WADE 3,701 20 3,766 11,370.35 9,176.39 2,193.96 19.30 7,249.52 1,926.87 21.00 192.69
6238: TOM K 69 20 130 9,317.36 7,211.61 2,105.75 22.60 5,710.28 1,501.33 20.82 150.13
6204: SHARON T 5 12 113 12,763.98 11,143.50 1,620.48 12.70 9,717.43 1,426.07 12.80 142.61
6210: SHARNA 1,320 16 1,367 8,325.51 7,444.20 881.31 10.59 6,033.96 1,410.24 18.94 141.02
1234: MARTY 314 16 377 16,869.83 13,822.39 3,047.44 18.06 12,449.29 1,373.10 9.93 137.31
6208: CHEYE 107 23 279 12,630.98 9,136.99 3,494.00 27.66 7,885.77 1,251.22 13.69 125.12
6225: BRAD_M - 6225 6 14 50 8,904.74 7,062.45 1,842.29 20.69 6,371.95 690.50 9.78 69.05

HI Folks, I?d love some help with a formula that would allow me to search a sales result spreadsheet and retrieve specific data from each salesperson to put into another spreadsheet. Due to the salespeople selling differing amount each day, the position of each name is changed daily.
I would like to search for a salesperson (e.g.; 1234: MARTY) then retrieve the data from say column 4 that corresponds with his name, and have this information pulled into another spreadsheet.


TIA

//Geof Davies



EggHeadCafe - Software Developer Portal of Choice
DataConnections in InfoPath 2007- Part I
http://www.eggheadcafe.com/tutorials...in-infopa.aspx

Geof
Name the range of your data above in your source file after first giving each column a unique name then
In your results spreadsheet try using "data...Get external data...Excel files" Choose your source data file then use the wizard to select your columns and criteria
if you are using excel 2007 it is "Data...From other sources...from microsoft query"