nested IF -then statement, vlook up and match!!

**rise99** · 11-02-2012, 12:44 AM

Hello!
I have a spreadsheet 2 columns and 7000 rows. if I have:
column: A column: B
red blue
orange green
... ...
All these "words" repeated in the entire table, I need to do a multiple if statements
If A=red and B=green, then c= OK
if A=orange and B=blue, then c=why
I have like 27 (if - and - to match) and also to search 7000 rows and find these matches??

I need your help plz!!

In the attached file:
I need say : if A="kkkk" and B="VVV" then C="MMM"
from A1:A143, B1:B143 and C1:C143 are repeated "may be randomly" to ~ 7000 rows

in other words I need to complete column C, for the whole worksheet.
Thank you!

**:) Sixthsense :)** · 11-02-2012, 12:47 AM

You will get a quick soclution if you post a sample workbook with all your 27 criteria's defined somewhere in the worksheet.

**FDibbins** · 11-02-2012, 01:18 AM

you have 27 DIFFERENT things you want to test for???

as suggested, perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.