I'm trying to write a vlookup that will look at an array of 3 columns.... the vlookup returns the second column but if there is an NA in the second column then it moves to take the value in the thirs column. Is this possible? I have attached an excel as an example. thanks
![]()
Bookmarks