Help with a lookup

[Fernando Salgueiro]

I have a table with 6 columns and I need a formula that count the numbers of times that "End A"  and "End B" shows for example row 3 and 4 match columns A (A3 = B205 and A4 = B205) and E (E3 = B260 and E4 = B260) so the formula in row 3 it will show as blank but in row 4 it will show count 2 of B205 & B260. The problem is when has more than 2 equal the formula have to look up without entering any information if up contain the same information.  

[#2]

If I am correct, the vlookup function only allows you to check for one condition. You may want to look into using the sumifs function as you can use multiple conditions to work with and then use the count function within it too. It also has many other advantages than vlookup cannot do. Hope it helps!

[#3 · Accepted solution]

Hi Fernando,

Please try this formula in cell F2

=IF(COUNTIFS($A$2:A2,A2,$E$2:E2,E2)=1,"",COUNTIFS($A$2:A2,A2,$E$2:E2,E2))

And find it in the attached file.

Regards

[#4]

Thanks