so I am having a hard time extracting data from different sheet ...
I want to type a number or the line & I get the info in the other sheet
take a look at my excel file & u will get what I am trying to do :
so I am having a hard time extracting data from different sheet ...
I want to type a number or the line & I get the info in the other sheet
take a look at my excel file & u will get what I am trying to do :
Last edited by zitno; 12-20-2014 at 02:07 PM.
Couple things with your given setup I would type in A4
Being that you named A2 CriteriaPlease Login or Register to view this content.
Then starting in B4
Now if you would add your Headers from the lookup sheet to the results sheet or OUTPUT then you could use this starting in A4Please Login or Register to view this content.
But again, that Index match requires that you put the headers in row 3 to match the headers from the index range row 1Please Login or Register to view this content.
-If you think you are done, Start over - ELeGault
yea :P ... well I am noob can u make it easier for me :P ...
thanks for ur help
Use this formula in A4 and pull it to the right
=VLOOKUP(Criteria,'base de données'!$A$2:$F$6,COLUMNS($A:A),0)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
guys I get err .. but I think it's bcuz I am suing french version of Excel
I think there is a confusion to understand the requirement.
On the Output sheet, you have entered 4 in A2 and you want the matching record on row 4. So if you enter 5 in A2, do you expect the row 5 to populate with the matching record? Or it is always row 4?
BTW If you are open to a VBA solution, find the attached sheet and input a row number in A2 and the record will be populated in row 4. See if this helps.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
it works :D ... thank you guys so much ^_^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks