you could try wrap the TEXT function around your vlookup.
it should return your lookup as a text string in the "00-00-00" format then.![]()
=TEXT(VLOOKUP(A1,table1,colno,FALSE),"00-00-00")
you could try wrap the TEXT function around your vlookup.
it should return your lookup as a text string in the "00-00-00" format then.![]()
=TEXT(VLOOKUP(A1,table1,colno,FALSE),"00-00-00")
2+2=5 for extremely large values of 2.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks