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:44 AM

jonnie_rc

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

Office 2010 64bit

Novice

Join Date: Aug 2017

Posts: 9

What i am trying to do is conver the QAP code to the QAR code in column 2 in the Rate Summary. However if the reference code is already a QAR code i do not want to change it.

Does that make sense?

This is why i have the logical test on the IF statement referencing the P in the reference cell C5.

« 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 03:37 AM.