Results 1 to 13 of 13

Combine VLOOKUP with TEXT Conversion?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Combine VLOOKUP with TEXT Conversion?

    Hi,

    Im performing a VLOOKUP to return a decimal value:

    =VLOOKUP(A15,wk_2,17,FALSE)

    I then want to combine that with something like

    =TEXT(A15/(24*60),"[h]""hr ""m""m""")

    so that it converts the VLOOKUP number into hours and mins, whilst annotating accordingly. Im a bit stumped, could anyone help?

    Thanks
    Last edited by Barking_Mad; 11-03-2020 at 12:12 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VLOOKUP returns 0 after text conversion
    By NielsvB in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-17-2020, 10:24 AM
  2. Conversion from numbers with text to simply a number without text or zero.
    By RigbyDigby in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2019, 12:03 PM
  3. Replies: 4
    Last Post: 11-08-2017, 01:54 PM
  4. VLOOKUP conversion formula help
    By mgmacha71 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-17-2016, 11:11 PM
  5. How to combine vlookup and search text within cell
    By garriebartolome in forum Excel General
    Replies: 3
    Last Post: 04-14-2011, 09:43 AM
  6. Replies: 4
    Last Post: 04-14-2011, 06:56 AM
  7. Replies: 7
    Last Post: 12-11-2009, 05:03 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1