Excel Help

[raviappadoo0673 (Ravi6008)]

I have been tasked to run an Excel spreadsheet and populate it, at the moment, it is a manual process, but I am sure there is an Excel wiz out there that can come up with a macro or formula that can crack this.

So i have a master spreadsheet with the raw data then i have a second spreadsheet that i want to populate. All my colleague wants to do is populate one field with device type and at the moment, i am having to copy surname, go to second spreadsheet and click find, then i find the surname and then it finds the device type and then i copy device type and put into my spreadsheet, but i have over 2000 rows to do.

Please help if possible

Screen shot one is the master spreadsheet with raw data, Screen shot 2 is the spreadsheet to populate.

Hope you can help

[rinomardo2 (badbanana)]

to make it easier, in the sheet2, split it into first name and last name.

then you could put below formula in your spreadsheet where

lookup_value = last name

sheet2!$a$1:$b:$3 = the cell range in sheet2 where it will search

= the column for the device

=vlookup(lookup_value,sheet2!$a$1:$b:$3,,FALSE)

[raviappadoo0673 (Ravi6008)]

Hi Badbanana,

any chance you can knock up a quick spreadsheet with the formula in with a little test data,

appreciate your help.

Regards
The One 007

[rockn]

Please do some of the work yourself. badbananna has given you more than enough info to get you started.

[raviappadoo0673 (Ravi6008)]

Understood Rockn, i am a bit of a novice when it comes to excel, but will try.

Regards

The One