Is vlookup the correct formula to use for my task?

5 pts.
Tags:
Excel formulas
Microsoft Excel
VLOOKUP
This is the formula that I am trying to write: When the cell row values in columns A and B, are equal to the cell row values in colums E and F are the same, I would like that information to appear side by side in separate colums for comparison. For any company data that does not match with vendor data, I would like to see some sort of alert flag. Can you please assist with helping to write this kind of formula? A sample of what I am working with is attached. Thank you in advance.
ASKED: September 4, 2008  3:54 PM
UPDATED: September 16, 2008  3:20 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I think that this formula may help, if I understand your scenario correctly
=IF((AND(A1=E1,F1=B1)),”OK”,”NO”)

Not a VLOOKUP, I know, but I think that this may be easier to manage, hope it helps

To perform a VLOOKUP, to the best of my knowledge, the function will only refer to one variable, you may have to setup 2 VLOOKUP queries and then combine the results and perform the IF function as above

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following