I am trying to compare the text in let's say A1;e.g. "Consumer" for instance, to one of the text values below, and if the text matches, populate say B1 with the applicable time (in days); example 20. If the value in A1 does not match any listed below, then I would default to "30". I attempted to write this as multiple 'IF' statements but got the error "too many nested formulas". Any suggestions. I have never used the VLookup function and didn't know if that may work. I have Excel 2007.
"Expected Turntime (all other values, default to '30')
values must be typed exactly as written below - spacing, punctuation and capitalization must be the same"
Better Business Bureau 20
U.S. House of Representatives 20
U.S. Senate 20
Media 20
Media NOT on behalf of customer 20
Media on behalf of customer 20
Consumer to Executive 20
Federal Deposit Insurance Corporation (FDIC) 20
Federal Reserve Bank 20
Consumer 25
Bookmarks