Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Formula help Formula help
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-30-2022, 11:47 PM
ArviLaanemets ArviLaanemets is offline Formula help Windows 8 Formula help Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Into D2 enter formula
Code:
=IFERROR(VLOOKUP(MID((SUBSTITUTE($A2," ","")),3,2),$H:$I,2,0),"")
and copy down!

Use SUBSTITUTE in 2nd formula too!
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Copy Row 2 Row But Next Column In Formula From Another Tab TimG Excel 3 04-16-2018 09:20 PM
Help with an IF Formula Cbate Excel 1 08-17-2017 07:29 AM
Formula help Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Formula help WHEN formula agent007 Excel 5 02-06-2014 09:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:16 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft