LinkBack URL
About LinkBacks
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.
i think the format in that code may not return what you need if the values have leading zeros
try replacing the last part with
"0##\-0##\-0##"
Thanks Ian
=TEXT(VLOOKUP(J9,'[other-worksheet.xlsx]Sheet1'!$D$3:$I$1151,1,TRUE),"0##\-00##\-0##\")
It's returning - #VALUE!
With FALSE I'm getting #N/A
Sure this is something really obvious that I'm missing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks