#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Hi could you please post a sample sheet ( no pics pse) ? Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
When using multiple criteria, I usually fall back on Sumproduct. See attached.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I think I need an IF/AND & VLOOKUP formula here | Catbert | Excel | 18 | 08-25-2013 07:38 PM |
VLookup formula Problem (salary plus (commission x sales)) | topgear2015 | Excel | 11 | 06-05-2013 09:02 PM |
VLookup is giving me #N/A error, help with data or formula? | ladygogo78 | Excel | 3 | 10-22-2012 12:28 AM |
IF + VLOOKUP formula help | skyline255 | Excel | 0 | 09-19-2012 05:05 PM |
Help with VLOOKUP formula | pattyr | Excel | 6 | 08-20-2012 02:20 AM |