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...