I have everything set up correctly for the function, but one of the requirements is
. If the position entered is not a valid position or is misspelled, the word Invalid should be displayed in the cell.
The function is
=IF(G15=$C$5,0,VLOOKUP(D15,table1,2,TRUE))
What would I add to make this correct?
Thank you!
Bookmarks