Excel Help ... Worksheet consolidation/merge

[pelparc]

I hope someone can point me in the right direction. I have 2 worksheets that both have a matching column title (sku number) and some matching cell text (the sku numbers). How do i create a 3rd sheet displaying a merged version of the 2 other sheets so that i only see the common sku numbers with the associated other column cells? I have tried using the consolidate feature but i cant get it to work (its probably me missing something simple). Thanks

 

[GraemeL]

Possibly a Pivot Table would work for you.
G

 

[pelparc]

Thanks GraemeL, i will have a good play tomorrow, but i think the drop down filters might get in the way when i try and import it.

 

[GraemeL]

If thats an issue, then a vlookup might work - should more filtering be needed then use IF.

G

 

[pelparc]

Thank you so much GraemeL, vlookup is perfect and so simple. Amazing how simple it is if you know what you are doing.