A day of formulae hell

[excelsos]

if(E2=California),Vlookup(D2,'CA Counties'!A1:C2330,2,"")

Ok - Today seems to be the day of mishaps.

so I have a spreadsheet with multiple tabs:
1 - Has California Counties.

I basically need to have it look up on Sheet 1 - California (If the state name= California), then I need it to look up the city name in the current sheet and then link to this sheet called CA Counties, adn return the name of the county

 

[excelsos]

I got it to work. I missed the reference totally. TY

 

[jtakw]

Hi,

I posted a solution for you in your other thread: https://www.mrexcel.com/forum/excel-questions/1050488-sos-not-working.html

The IF(OR formula in your OP can be simplified a bit like in D1 below(from your other thread), D2 might be what you need for your question in Post #7 from your other thread and here :

Excel 2010
	D
1	0
2
Sheet10

Cell Formulas
Range	Formula
D1	=IF(OR(C5={"Dollar General","Family Dollar","******* Barrel","Reserved"}),R5,0)
D2	=IF(E2="California",VLOOKUP(D2,'CA Counties'!A1:C2330,2),"")

 

[Scott T]

You should remove the ) after E2=California as that is closing the if statement I assume you want to return blank if E2 does not = california

=if(E2=California,Vlookup(D2,'CA Counties'!A1:C2330,2,0),"")