Hello, how can I check if a row in a table contains a given value? I was thinking to use COUNTIF + VLOOKUP but it doesn't work, because I can't use the VLOOKUP as a range in the COUNTIF formula.
|
A |
B |
C |
D |
E |
F |
1 |
ID |
C1 |
C2 |
C3 |
C4 |
C5 |
2 |
A |
1 |
6 |
13 |
19 |
33 |
3 |
B |
2 |
5 |
16 |
22 |
29 |
4 |
C |
3 |
7 |
14 |
29 |
35 |
I have the ID and I have to check if the ID row contains the given value, my idea was to use this formula:
Formula:
=COUNTIF(VLOOKUP("B",A2:F4,{2,3,4,5,6},FALSE),22)
Because the B row contains the value 22 I was expecting to get a 1, but excel doesn't accept the formula.
How can I solve this problem?
Bookmarks