Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is VLOOKUP and HLOOKUP the answer?

Status
Not open for further replies.

quig699

Technical User
Nov 7, 2006
42
US
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
 
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]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
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
 
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
Code:
[b]    E          F[/b]
James Smith    30
James Bond    509
Sally Star    323
Is that what you need?

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top