get the value from the formula

[eQuestion]

Hello guyz!,

GOOD AFTERNOON TO YOU ALL! I have this formula on my sheet ==VLOOKUP(A1,RECDBASE!A1:N458,10,FALSE), the result is something like this --> QQ 564879, how can i get the values only in that formula and put it in a cell by a function or a formula?

THANK U IN ADVANCE!

[Steven_Daniel]

Hello eQuestion

I am not too sure what you are wanting to see. If you are wanting to return the numbers from ie., QQ 564879 which would be 564879 then this formula would do the thing for you.

=IF(ISERROR(VLOOKUP(A1,RECDBASE!A1:N458,10,FALSE))=FALSE,RIGHT(VLOOKUP(A1,RECDBASE!A1:N458,10,FALSE),LEN(VLOOKUP(A1,RECDBASE!A1:N458,10,FALSE))-2),"")

Just copy the formula in your cell and paste down.

Hope this is what you are after, if not, are you able to upload a file attachment so that I can see what you are wanting to achieve.

Cheers,

[eQuestion]

Hello Steven,

In my other thread you already gave me the solution, thank you so much for that, i have no idea that you can combine this formulas into one! So, i'll just apply it in my worksheet.

THANK YOU SO MUCH AGAIN.

[Steven_Daniel]

Hi eQuestion

Great! glad that my solution helped you out. Thanks again for the feedback.

Cheers,