Forum Discussion
VLOOKUP
I am not yet familiar with the VLOOKUP function. I want to create a formula where it will reference something in Column A (Alphanumeric field) and several lines in Column A have the same number. Af...
That could be
=IFNA(INDEX($D$6:$D$20,MATCH(N18&N19,$A$6:$A$20&$C$6:$C$20,0)),"no such")Please check attached.