IF STATEMENTS NOT WORKING
Thank you,
"T. Valko" wrote:
Another way:
Create a 2 column table like this:
...........I..........J..........
1....Farm......FEDERAL FARM CREDIT BANK
2....Home....FEDERAL HOME LOAN BANK
3....Natl.......FEDERAL NATIONAL MORTGAGE CORP
Then use this formula:
=LOOKUP(2,1/(ISNUMBER(SEARCH(I$1:I$3,A1))),J$1:J$3)
--
Biff
Microsoft Excel MVP
"Iguss" wrote in message
...
I have the following
FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK
FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK
FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP
=IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME
LOAN
BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION","")))
Can you please advise why a following formula doesn't work and how can I
correct it.
Thank you
|