Forum Discussion
Solved
Help with a lookup
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 a...
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
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!