Thread: [Solved] Vlookup formula
View Single Post
 
Old 03-18-2014, 12:20 PM
teza2k06 teza2k06 is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default Vlookup formula

I am needing help with a Vlookup if it is possible.

I have a spreadsheet with names, First Name in Column A, Surname in Column B, and Column C as ID Number. The only 2 fields that are filled out as A&B(their names).

I run a report which opens another spreadsheet which shows their name and the ID Number, now instead of manually typing the ID from one spreadsheet to another i was hoping i could use a vlookup(or something) to find the first name and surname on the report and it then add their ID to my spreadsheet

I think i have made the above understandable, if it is not possible to use vlookup, then can you suggest something. Im not an expert with excel so i may need a hand

Thanks
Reply With Quote