Hi all,

Sorry struggled to put a title. I'm trying to work out a formulae for Excel to help me assign users to certain groups.

The excel document contains two sheets of text data and I need to pull data from one sheet and add it to the next if it meets certain criteria.

I need the formulae to search sheet 1 to search text from column A and match that containing text with Sheet 2 column B (matching usernames). When match is found I need excel to pull the cell adjoining on sheet 2 to new column in Sheet 2.

Struggling to explain as you can probably tell.

Thanks,