You are viewing a single comment's thread from:

RE: How to carry out a VLOOKUP within Text in Excel

in #excel • 6 years ago

@theexcelclub that was an excellent post and tutorial. I 100% enjoyed carrying out the learning activity. Here are my answers

What text function is needed in this case?

I would use the MID function

What is the full formula that you used?
=vlookup(mid((a2,4,2)+0,E1:F7,2,false)

6 years ago in #excel by
$0.21
  • Past Payouts $0.21, 0.00 TRX
  • - Author $0.16, 0.00 TRX
  • - Curators $0.05, 0.00 TRX
2 votes
Reply 1
Sort:  
  • Trending
    • [-]
     6 years ago 

    Nice work @dernan, you are correct. thank you for taking part in our learn and earn activity

    $0.00
      Reply

      Coin Marketplace

      STEEM 0.16
      TRX 0.15
      JST 0.030
      BTC 58510.90
      ETH 2522.39
      USDT 1.00
      SBD 2.36