• Sign in
  • Sign up 
  • Welcome
  • FAQ
  • Switch to Night Mode
  • Stolen Accounts Recovery 
  • Change Account Password 
  • Vote for Witnesses 
  • Steem Proposals 
  • Developer Portal 
  • Steem Bluepaper 
  • SMT Whitepaper 
  • Steem Whitepaper 
  • Privacy Policy
  • Terms of Service
Homeby Witness Moecki
LoginSign up
You are viewing a single comment's thread from:

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

  • View the full context
tansm11 (46)in #excel • 5 years ago

Excel Learn and Earn Activity 6:
What text function is needed in this case?
MID
What is the full formula that you used?
=VLOOKUP(MID(A2,4,2)+0,$E$1:$F$7,2,FALSE)

5 years ago in #excel by tansm11 (46)
$0.21
  • Past Payouts $0.21
  • - Author $0.10
  • - Curators $0.11
3 votes
  • + paulag
  • + theexcelclub
  • + anomaly
Reply 0