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 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.
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
3 Replies
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
- Thanks
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!
