Alright so basically what i have is a three sheet workbook.

Sheet 1 = Delivery report with item numbers.
Sheet 2 = 800 different item numbers, each on their own line
Sheet 3 = what i need done will go here.

Basically what i want excel to do is check my delivery report for all 800 different items and put the matches in Sheet 3.

I want to have sheet 3 show me the items that are coming in that match my list in sheet 2.

Does anyone know a formula or function that would work!?
Thanks

 

I don't have all the steps, but I believe what you want to use is VLOOKUP.

 

Not quite sure I understand what you are trying to do. But I think the VLOOKUP should work.

If that doesn't work, you might mess around with the IF THEN function, that can get pretty involved though.

 

how is your data getting into sheet 1, do you have a sample you can send.

 

Vlookup is the answer I believe.

 

Thanks Guys

Vlookup is exactly what i needed. I figured it out last night at 1:00AM haha.

Now what i need is a way to sort all the data on a final sheet.

The reason being i have 800 skus to check. So it may find one at A1 or it may find one at A800 and anywhere in between. Instead of scrolling through i need a way to LIST only the valid cells.

I tried a pivot table but its hard to format and won't refresh. I used a Visual Basic script to do a refresh but it only works sometimes and I think my corporate network blocks Scripting.

Any help again!? you guys are pretty good

 

Would adding a filter do the job? You can search within the filter.

 

Record a macro for the refresh. If you cannot run macros you might be able to enable under security settings.

 

Just looking into the filters now. Recording a macro would most likely have the same restrictions on the network.

 

Filter is working. But It does not auto refresh lol

 

You can make a pivot table auto refresh by click on the red ! point. It will then refresh your pivot table base on the new data.

I believe this is what you're after anyways.