How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'

**goonshiredgoons** · 10-12-2015, 06:34 PM

OK so forgive my roookieness on this one I cant even paste a table in here so excuse the screen shots (help on this might be nice too

)

I'm trying to understand the ways (I'm sure there may be many) that I can put the supervisors name on the same row when I only have their ID number

The first sheet is where I want to impose my data and fill for ?

find.png

The second sheet tells me the Supervisor ID-Name matchup

source.png

Its my first post and hopefully the start of a deep dive into excel, hopefully Ill pick up the lingo soon

Thanks

**Sam Capricci** · 10-12-2015, 06:38 PM

On your first sheet use =VLOOKUP(c2,[second sheet]A:B,2,false) to get it

**FDibbins** · 10-12-2015, 06:57 PM

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

**goonshiredgoons** · 10-13-2015, 11:22 AM

thanks for responding guys and sorry about the screenshots it was madness I know..

& here is a sample of the workbook I'm trying to get the grips of this on, is a Vlookup the recommended way of doing it?

If this was something I needed to repeat would I be better off going down the Macro route?

NameIDmatch.xlsx

**JohnTopley** · 10-13-2015, 11:25 AM

=VLOOKUP(C2,Sheet2!$A$2:$B$6,2,0)

as per "Sambo Kid" reply

**goonshiredgoons** · 10-13-2015, 03:40 PM

wow thanks

**FDibbins** · 10-13-2015, 03:41 PM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'

LinkBack

Thread Tools

Rate This Thread

Display

How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'

Re: How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'

Re: How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'

Re: How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'

Re: How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'

Re: How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'

Re: How do I pull and place 'Name' data from Sheet to Sheet based on 'ID'

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Pull data from another sheet based in criteria

Formula to pull data from one sheet to a new sheet based on date range

[SOLVED] VBA Code to Pull Data from a Sheet Based on Date and Add that Data to Another Sheet

[SOLVED] Pull Data from one sheet to another based on 4 conditions.

[SOLVED] Excel Formula to pull data from another sheet and place cell blank if value is 0

How to pull data from one sheet into new sheet based on two criteria

? how to pull data from another sheet based on value

Bookmarks

Bookmarks

Posting Permissions