IF formulae needed

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,

Hi,

Would it be something like this that you are looking for.

I have put UserNames on Sheet 1 and the other details on Sheet 2. I have used Index and Match to find the name in Sheet 1 on Sheet 2 and enter the relevant P'Word.

I have only used this info, to illustrate what I have done - as often UserName and Password go together.

Regards,

Sonia

Hi,

Thank you both for your help. Sorry I could respond I was away for the weekend.

Attached is the date I'm looking for a formula for.Dummy Data.xlsx

I'm after the charity the support from sheet 1 to be added to the last column in sheet 2.

Thanks again

Hi,

I've added a further column in Sheet 1 for USERNAME. Splitting your original COLUMN A into two parts enables you to use a lookup to obtain the CHARITY information you're looking for. Hope this helps?

Hi,

Cheers that works. Is there an easy way of splitting Column A, as the actual document is about 600 lines?

Thanks,

I've attached a further file which hopefully meets your requirements.

In short, I've inserted a new column (B) on Sheet1 which extracts the username from the data in brackets from column A. This is an array formula so should be entered using CMD+SHIFT+ENTER (Mac) or CTRL+SHIFT+ENTER (Win).

Then I've adjusted the original lookup to use the new column as it's starting point in the lookup. Looks to be working from here.

That's spot on. thank you so much for your help