Is VLOOKUP and HLOOKUP the answer?

[quig699]

Hi,
I was looking for a way to pull information from a report that exports to an Excel spreadsheet. The spreadsheet is ugly and was looking for a way to pull just the data I needed. The report has the agent’s name on row 1 column 2. The data I need for the rep is two rows down in column 3. I looked into VLOOKUP and HLOOKUP but haven’t been able to find a way to make it work. Does anyone have any ideas I could try?

Thank you
Amy


Thanks,

Amy

 

[SkipVought]

hi,

The report has the agent’s name on row 1 column 2. The data I need for the rep is two rows down in column 3.

That is not how Excel is designed to work with lookup functions.

Please post a representative sample of data (copy 'n' paste), your lookyp value and the data you wish to return.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[quig699]

Hi,

here is the example. Thanks!!

Calls Orders Issues

James Smith

18 16 30







James Bond

98 54 509







Sally Star

76 33 323







Jane Doe

114 67 509


Thanks,

Amy

 

[SkipVought]

I have the lookup values in column E & the formula is column F...
[tt]
F1: =INDEX(A:C,MATCH(E1,B:B,0)+2,3)
[/tt]
My results

[b]    E          F[/b]
James Smith    30
James Bond    509
Sally Star    323

Is that what you need?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]