|
|
#2
10-03-2016, 03:25 PM
|
|||
|
|||
Hello & Welcome to the Forum,
On sheet2 in B2 copied down.... ...I think you are looking for =VLOOKUP(A2,'SHEET 1'!$A$2:$B$10,2,0) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
 using two lookup values to get a sum figur
|
Ian A King | Excel | 3 | 05-18-2015 02:56 PM |
|
Lookup / Paste Multi Values VBA
|
Mav | Excel Programming | 6 | 05-10-2015 08:42 PM |
| Lookup multiple values and compare different scenarios to get a specific result | mws | Excel | 5 | 05-24-2014 04:52 AM |
| How can match or lookup values from two separate tables? | klawk26 | Excel | 1 | 07-31-2012 09:04 PM |
Windows Vista 
Office 2007
Threaded Mode