Is vlookup the correct formula to use for my task?
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 4, 2008 3:54 PM
UPDATED:
September 16, 2008 3:20 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
