![]() |
|
|
|
#1
|
|||
|
|||
|
In sheet 2 Column C2 result should be RB3043, RB3043, RB3043,
But getting only one may be the same value. But i wanted to get these three DO NOT ignore duplicated values and need to get that too. |
|
#2
|
|||
|
|||
|
I got the answer when i have removed the UNIQUE function.
thanks very much |
|
|
|
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 |
Lookup
|
Tony Singh | Excel | 3 | 03-06-2015 11:03 AM |
| Lookup | angie.chang | Excel | 1 | 07-27-2012 09:45 PM |
Possible Lookup
|
Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
LookUp
|
aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |