User Profile
theboth
Copper Contributor
Joined Nov 06, 2023
User Widgets
Recent Discussions
Wrong formula, can't figure out.
So I have this tables for example. In column K i want a formula that compares values from column G and column I to column A and B and finds the right row it's in, and also puts the right value in column K. as you can see, it's not doing what it's supposed to do. here is the formula in written form: =IF(AND(ISNUMBER(MATCH(G10; A5:A14; 0)); ISNUMBER(MATCH(I10; B5:B14; 0))); VLOOKUP(G10; A5:C14; 3; FALSE); "") What is wrong with it?
