|
|
#1
02-12-2017, 09:54 PM
|
|||
|
|||
Return value base on two columns
Hi All,
Attached image is my data format. I need a formula in column L to return the value according to column A and B. For example, row 3. Col A = E1 and Col B =D then it should return value in "C3" which is 5. Row 4, Col A = E2 and Col B = M then it should return value in G4 which is "8" How can I write this formula? Anyone can help ASAP? I need it urgently. Thanks in advance!!! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel / Mail Merge - Return Column Headers for All and Any Columns with Values
|
eduams | Mail Merge | 1 | 09-26-2016 07:02 PM |
|
Compare cells in 2 columns in separate WBs and return data in Col 38-40 if there is match
|
krispykreme | Excel Programming | 1 | 09-09-2016 11:25 AM |
|
Creating small data Base
|
quintinros | Excel | 2 | 06-26-2014 12:28 AM |
| Vlookup two columns return 3rd | jennamae | Excel | 11 | 01-12-2014 02:53 AM |
| Calendar Base | prayojana | Project | 0 | 11-12-2007 01:13 AM |
Windows 7 
Office 2007
Threaded Mode