Hi,
i have a complicated vlookup/index/match .. whatever formula will work,
On my sheet "Main", column A, i have a list of phone numbers, so lets say 555-555-5555, this number is also in worksheet "ListeALL" in column N.
i need a value return on both condition...
In sheet "ListeAll", if column b = FÉVRIER and column N = (phone number in MAIN column A), then return me the Value in column F
MAIN
A B
8191245784 (FORMULA TO RETURN VALUE AN if A is met in LISTEALL N and FÉVRIER in B)
LISTEALL
A B C D E F G h I J K L M N
Kia Sherbrooke FÉVRIER 604111 12-02-15 20:33 27-02-15 00:00 AN 2006 kiashfev0009 13201 -4.00 N 1 8191245784
Kia Sherbrooke FÉVRIER 604114 12-02-15 20:33 26-02-15 00:00 AN 2088 kiashfev0012 13201 -4.00 N 1 8191546781
Bookmarks