I get a data pull that is hh:mm:ss but its 'text' and =ISNUMBER i s FALSE. I do a vlookup to pull the numbers, how would I create a convertion formula, I can't reforemat to number it doesn't allow me to.. I've looked through the forum and couldn't find something to do this. If IS NUMBER = FALSE, can it be converted to a number?
=if(isnumber(a1),a1,a1*1)
Does this work?
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Yes my friend it does, thank you!!
How would i write this into a vlookup like this?
=IFERROR(if(ISNUMBER(u8),u8,u8*1(VLOOKUP($A8,'Availability '!$B$3:$AI$3265,6,FALSE),"No Data")
I do not understand well enough
Post a xls file please
Here's an example - reference column V the highlighted red column... I want to convert the text using =IF(ISNUMBER(A1)A1,A1,A1*1) Want to use this in the Vlookup formula.
Nope.. still can't work this into the vlookup... ugh
Last edited by BenCrockett; 10-18-2013 at 02:19 PM.
I can't see where it goes wrong.
where goes it wrong and what value you would expect.
I am doing a vlookup to get the time, it comes in as text, and I need it to be a number value, because I have to conditional formatting and calculations based off the time.
Is there a way to convert the text into numbers in the vlookup argument?
=IFERROR(VLOOKUP($A8;'Availability '!$B$3:$AI$111;10;FALSE)*1;"No Data")
Try this
Yup, that worked perfectly, seems too simple haha... thank you very much, Much apprecaited.
I think you want:
=IFERROR(VLOOKUP($A8*1,'Availability '!$B$3:$AI$111,10,FALSE),"No Data")
Hope this helps.
Pete
The simplest solutions are the hardest to find.
That's always the problem with me hah.. Thanks again poppipipoOriginally Posted by popipipo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks