I have a sheet that has 4500 items on it and want to create a new sheet so I can type in a part number and get the information on the row that number is on.
so in the (new blank sheet) cell a3 will be the input cell and cell a5 to a9 will show the data.
Last edited by komet12; 02-05-2014 at 08:29 AM.
Would that be only one column?
Could you attached an example?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Here is an example. The look up is in a single column and info will be in a single row There are no duplicates
Hi All,
in A6
then copy and paste special formula to the right.
Please Login or Register to view this content.
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Re: Some advice and help
Thank You Very Much that solved my issue !!!!
Last edited by komet12; 02-04-2014 at 11:27 AM. Reason: SOLVED
Hi,
thanks for your feedbacK: you're welcome.
Regards
One other thing in the example I showed you is there a way I could search for just a product name like belt and and have it show all the belts and information regarding them??
example1find.xlsx
=IFERROR(INDEX(INFO!A$2:A$1000,SMALL(IF(INFO!$C$2:$C$1000=$B$2,ROW(INFO!$B$2:$B$1000)-ROW($B$2)+1),ROWS($A$2:A2))),"")
Confirm COntrol+Shift+Entert
That worked fine (Except)I would put in a part and it would give me the correct rows like I had 8 Bolts but Line ID was 10 off so i changed the -ROW($B$2)+1 -ROW($B$2)+11 and it works GREAT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks