Hi,
The following formula brings the value from Sheet Marks to the current cell in a different sheet where the formula is written:
=IF(VLOOKUP($A$3,Marks!$B$14:$ED$79,122,FALSE)="","",VLOOKUP($A$3,Marks!$B$14:$ED$79,122,FALSE))
The values in sheet Marks are either: 1, 2, 3 or 4. What changes should be done to the formula so that it shows the value instead of the number?
Below is the corresponding values:
1 = Always
2 = Most of the time
3 = Sometimes
4 = rarely
Khalil
Bookmarks