|
|
#1
08-28-2012, 12:50 PM
|
|||
|
|||
Vlookup
Can somebody please help me with a vlookup formula? If A1 matches E1, I need it to insert F1 into B (I tired to copy and paste the table in, but it smooshed it all together)
A1 - 001 B1 - #N/A C1 - 53729 D1 - 5024722001 E1 - 101 F1 - 20B The formula I created is =VLOOKUP(A1,Divisions,2,FALSE) Divisions = E & F What am I doing wrong? Last edited by kkerr; 08-29-2012 at 06:55 PM. Reason: Attaching a test file for example 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Vlookup
|
ibrahimaa | Excel | 5 | 03-04-2012 11:24 AM |
| Vlookup | ibrahimaa | Excel | 8 | 01-03-2012 09:32 PM |
| Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |
|
Can i do this with a VLookup?
|
foodstudent | Excel | 1 | 01-21-2011 12:34 AM |
| Using IF & VLOOKUP together | junction | Excel | 7 | 11-18-2010 05:15 AM |
Windows XP 
Office 2007
Threaded Mode