Formula help

		Microsoft Office Forums > Microsoft Excel > Excel
Formula help

03-31-2022, 06:27 AM

tispivey

Windows 11 Formula help

Office 2021

Novice

Join Date: Mar 2022

Posts: 4

Quote:

Originally Posted by ArviLaanemets

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!

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
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
WHEN formula	agent007	Excel	5	02-06-2014 09:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 PM.