Complicated Lookup in Excel
Solved/Closed
DCecil07
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
-
Aug 23, 2010 at 10:30 AM
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010 - Aug 26, 2010 at 11:58 AM
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010 - Aug 26, 2010 at 11:58 AM
Related:
- Complicated Lookup in Excel
- Number to words in excel - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
- Excel apk for pc - Download - Spreadsheets
5 responses
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Aug 23, 2010 at 12:45 PM
Aug 23, 2010 at 12:45 PM
DCecil07
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
Aug 23, 2010 at 09:07 PM
Aug 23, 2010 at 09:07 PM
I can see where you are going, but if you look at the Columns on the TECI Sheet, the fields aren't matching up with the "Key Fields" column.
This is pretty much taking a row from one sheet and transposing it to another.
I really appreciate all your efforts. I'm good at excel, just not THIS good.
This is pretty much taking a row from one sheet and transposing it to another.
I really appreciate all your efforts. I'm good at excel, just not THIS good.
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Aug 24, 2010 at 12:28 AM
Aug 24, 2010 at 12:28 AM
Tell Me In Which Cells You Want The Formula.........
Tell Me The Direct Patch Of Those Cells....
& Tell Me From Which Cell You Want To Lookup Your Data...
Tell Me The Direct Patch Of Those Cells....
& Tell Me From Which Cell You Want To Lookup Your Data...
DCecil07
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
Aug 24, 2010 at 06:08 AM
Aug 24, 2010 at 06:08 AM
I will be looking up the concatenated cells as the vlookup. Once the vlookup takes place, I need the Rows on the TECI rows to be transposed to the PTCI Column according to the POTS for Key Field Blank through 6.
Does that make sense?
Does that make sense?
Didn't find the answer you are looking for?
Ask a question
DCecil07
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
Aug 26, 2010 at 11:58 AM
Aug 26, 2010 at 11:58 AM
From the PTCI workbook, I have added the TECI workbook to 'SHEET1' on the PTCI. From there, I used this following formula to get the data that I needed.....
=VLOOKUP(H2,TECI,MATCH(G2,INDEX(TECI,1,),0),0)
H2 - Concatenated Data Field
G2 - Key Field
=VLOOKUP(H2,TECI,MATCH(G2,INDEX(TECI,1,),0),0)
H2 - Concatenated Data Field
G2 - Key Field