V-lookup a word in another sheet and return that word
I have two sheets in a workbook, I would like the v-lookup to return sub in Col B if found or par in Col C if found on the second sheet for the matched number is col A. The problem is when I did the V-loookup it gave me the first occurrence. How do I tell the V-lookup to look for that specefic word per each number in column A.
Workbook Sheet 1
Col A Col B col
5879 sub par
COL A COLB