Extracting the correct information

[Noxqss38242]

I'm wanting an easier way to pull information I need for work, any solution to this would be awesome!

I extract information and paste it on "sheet 2" which contains hundreds of rows and about 15 columns. In column "a" is the list of truck numbers (sometimes and often repeated), in column "h" is another number that I want to extract to "sheet1" based off what I enter in cell "a1" on "sheet1". So "sheet2" will look like:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD](Truck #)[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]Code[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[/TR]
[TR]
[TD]19848[/TD]
[TD][/TD]
[TD][/TD]
[TD]2467[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19848[/TD]
[TD][/TD]
[TD][/TD]
[TD]125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19848[/TD]
[TD][/TD]
[TD][/TD]
[TD]2467[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19848[/TD]
[TD][/TD]
[TD][/TD]
[TD]111[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19848[/TD]
[TD][/TD]
[TD][/TD]
[TD]5717[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19848[/TD]
[TD][/TD]
[TD][/TD]
[TD]125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

And I want to enter on "sheet1" the truck number and have it pull the codes relating to that specific truck number as there will be hundreds of other trucks listed as well, it can be with the duplicate codes but I would prefer it to not duplicate codes already pulled. So it would look something like this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Truck #[/TD]
[TD][/TD]
[TD]Code[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19848[/TD]
[TD][/TD]
[TD]2467[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]111[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]5717[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

If the truck number comes up with no match, then I would also like the cell to say, "no codes" or if easier, to just be blank and not an error.

Essentially I'm going to lock down every other cell so others can access this information and only the A1 cell would be available to them and codes (if any) will populate into those cells so the individual can see if a specific truck is having "codes"/issues.

Any solution to this? Thank you!

 

[Noxqss38242]

Oh man! Well, that was it! It works perfect now!!! Pure genius!

 

[Aladin Akyurek]

Oh man! Well, that was it! It works perfect now!!! Pure genius!

Glad to help. Thanks for the kind update.