ghostbroker2
Board Regular
- Joined
- Feb 13, 2017
- Messages
- 58
[FONT="]Greetings!
[/FONT]
[FONT="]I've been using this formula to return the last non zero in column B to cell N3.
[/FONT]
[FONT="]
[/FONT]
[FONT="]=VLOOKUP(9.99999999999999E+307,B:B,1)
[/FONT]
[FONT="]
[/FONT]
[FONT="]Column B has a formula in it to automate the entry of employee numbers. it looks like this;
[/FONT]
[FONT="]
[/FONT]
[FONT="]=IF(C7>0,($B6),"")
[/FONT]
[FONT="]
[/FONT]
[FONT="]However now we are now using temps (temporary employees), and they have letters in their employee number.
[/FONT]
[FONT="]The VLOOKUP formula does not return the value if it is text.
[/FONT]
[FONT="]
[/FONT]
[FONT="]Can anyone suggest an alternative? I need cell N3 to be able to return a numeric or text value.[/FONT]
[/FONT]
[FONT="]I've been using this formula to return the last non zero in column B to cell N3.
[/FONT]
[FONT="]
[/FONT]
[FONT="]=VLOOKUP(9.99999999999999E+307,B:B,1)
[/FONT]
[FONT="]
[/FONT]
[FONT="]Column B has a formula in it to automate the entry of employee numbers. it looks like this;
[/FONT]
[FONT="]
[/FONT]
[FONT="]=IF(C7>0,($B6),"")
[/FONT]
[FONT="]
[/FONT]
[FONT="]However now we are now using temps (temporary employees), and they have letters in their employee number.
[/FONT]
[FONT="]The VLOOKUP formula does not return the value if it is text.
[/FONT]
[FONT="]
[/FONT]
[FONT="]Can anyone suggest an alternative? I need cell N3 to be able to return a numeric or text value.[/FONT]