Help needed with IF formula with a Vlookup

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

FAQ

Mark Forums Read

Thread Tools

Display Modes

08-31-2017, 11:38 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

The columns in your rates table need to be switched. What you are searching for, the QAR code, should be in the leftmost column and what you want returned, the QAP code, should be in some column to the right.

What is it you are trying to do here? Correct codes that are incorrectly entered?

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:07 PM.