Thread: [Solved] Formula help
View Single Post
 
Old 03-31-2022, 06:27 AM
tispivey tispivey is offline Windows 11 Office 2021
Novice
  
Join Date: Mar 2022
Posts: 4
tispivey is on a distinguished road
Default
Quote:
Originally Posted by ArviLaanemets View Post
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!
That worked! Thank you!
Reply With Quote