Excel formula needed to find string and then copy details from another cell

**jopat** · 12-09-2014, 08:43 PM

Hi All,

I have a spreadsheet with 2 Tabs. I'm wanting a formula to find the user name that appears in the User ID tab in Column A and pull the Full Name from Tab Employee Name and place this into the column B in User ID tab.

User ID.JPG Employee Name.JPG

Hope this makes sense. Thanks for your assistance

Thanks
Mal

**Tony Valko** · 12-09-2014, 09:08 PM

Try this...

=INDEX('Employee Name'!A$1:A$2,MATCH(A2,'Employee Name'!C$1:C$2,0))

**jopat** · 12-09-2014, 10:01 PM

Fantastic Tony! Thank you so much..... Worked perfectly!

**Tony Valko** · 12-09-2014, 10:10 PM

You're welcome. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

Excel formula needed to find string and then copy details from another cell

LinkBack

Thread Tools

Rate This Thread

Display

Excel formula needed to find string and then copy details from another cell

Re: Excel formula needed to find string and then copy details from another cell

Re: Excel formula needed to find string and then copy details from another cell

Re: Excel formula needed to find string and then copy details from another cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA help needed to find text string, clear cells then add new cell value

[SOLVED] VBA Needed to find number/text within cell string and copy out to new cell

Calculations by details -formula/VBA help needed

how to find Certain String in a column, select/Copy the cell till another String

[SOLVED] putting a string from one cell in the formula of another -- indirect needed?

Bookmarks

Bookmarks

Posting Permissions