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...
Larry1921 Another variant, in case your Excel version recognises the FILTER function.
=FILTER(D6:D16,(A6:A16=N18)*(C6:C16=N19),"None")
Thanks