Vlookup multiple criteria

[se7098]

A B
Hispanic or Latino White
Not Hispanic or Latino African American
Not Hispanic or Latino Asian
Hispanic or Latino Afrian American

If a = Hispanic or Latino and b= white return value of Hispanic or Latino
If a = not Hispanic or Latino and b=white return value of white.
If a = Hispanic or Latino and b = African American return value of Hispanic
or Latino (all other races)
If a=not Hispanic or Latino and b=African American return value of African
American

Can this be done with a formula? Thanks.

 

[se7098]

that seems to be getting me close...

however, in the situation where a=not hispanic or latino and b=asian i am
receiving a value of african american.

so what i need is to understand exactly what is happening within the formula
so i can know where to make adjustments

thanks!

 

[Eduardo]

Hi,
try

=IF(AND(A1="Hispanic or Latino",A1="White"),"Hispanic or
Latino",IF(AND(A1="Not Hispanic or
Latino",A1="White"),"White",IF(AND(A1="Hispanic or Latino",A1="African
American"),"Hispanic or Latino",IF(AND(A1="Not Hispanic or Latino",A1=African
American),"African American",""))))

 

[se7098]

you, my friend, are a genius...rock star of immense proportions! thank you
so very much!!!

 

[catts22]

Hi Can a Vlookup be done with 3 criteria?

I have this:

I have 3 columns on Sheet 1 and need to have the result in the fourth column
based on information on Sheet 2.

Sheet 1
A B C D
1 State City Address Company
2 AL Birming ALL
3 NC All ALL
4 NY New York 123 X St
5 NY Long City 999 A St

Sheet 2
A B C D
1 State City Address Company
2 AL Birming ALL Yellow
3 NC All ALL Yellow
4 NY New York 123 X St Red
5 NY Long City 999 A St Blue
6 CT ALL ALL Red
7 GA ATLANTA 5TH St Red

In D2 on Sheet 1 - I tried this formula with the idea that I need the
company name shown on column D of Sheet 2 if Column A,B,C match on both sheets

=INDEX('Sheet 2'!D2101,MATCH(1,(a2='Sheet 2'!A2:A101)*(b2='Sheet
2'!B2:B101)*(c2='Sheet 2'!C2:C101),0))

I keep getting # N/A - I took all formating out and on both sheets and made
sure there were no extra spaces etc.

On this formula I don't understand what the the 1 refers to after Match(1 -
I copied this formula from another post and edited it.

Thanks