Help needed with IF formula with a Vlookup

		Microsoft Office Forums > Microsoft Excel > Excel
Help needed with IF formula with a Vlookup

FAQ

Thread Tools

Display Modes

08-31-2017, 11:58 AM

gebobs

Windows 7 64bit Help needed with IF formula with a Vlookup

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

=If(Mid(D19,3,1)="P",Left(D19,2) & "R" & Right(D19,3),D19)

If the third character is always either P or R, then the If and Mid are superfluous and you could just use...

=Left(D19,2) & "R" & Right(D19,3)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
VLOOKUP Formula?	ekeithjohnson	Excel	6	08-28-2014 01:16 PM
Vlookup formula	teza2k06	Excel	2	03-18-2014 01:21 PM
I think I need an IF/AND & VLOOKUP formula here	Catbert	Excel	18	08-25-2013 07:38 PM
IF + VLOOKUP formula help	skyline255	Excel	0	09-19-2012 05:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 AM.