Forum Discussion
How to find a specific number from 2 columns
Source number Wanted outcome Question: a 1 Number is only from source a I like to know from what source is the number coming from? a 1 Number is from source a and b Is it alone from...
=IF(AND(NOT(ISNA(VLOOKUP("a"&B14,$A$14:$A$22&$B$14:$B$22,1,FALSE))),NOT(ISNA(VLOOKUP("b"&B14,$A$14:$A$22&$B$14:$B$22,1,FALSE))))=TRUE,"Number is from source a and b",IF(NOT(ISNA(VLOOKUP("a"&B14,$A$14:$A$22&$B$14:$B$22,1,FALSE)))=TRUE,"Number is only from source a",IF(NOT(ISNA(VLOOKUP("b"&B14,$A$14:$A$22&$B$14:$B$22,1,FALSE)))=TRUE,"Number is only from source b")))
Is this what you want to do? I understand that there are only 2 possible sources a and b and there can be numbers 6, 7, 8 and so on as well.
Thanks, yes this is what i need i guess. It looks like it will work. I have to translate the formula in dutch excel. Many thanks.