Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

IF Statement

Hi,

Im looking to get together an IF statement to say the following

If a2=travseam then "John Smith", if a2 = terryKe then "Harry potter" etc etc

Col A
travseam
terryKe
TANCH
etc etc

Thanks
Seamus
ASKER CERTIFIED SOLUTION
Avatar of stergium
stergium
Flag of Greece image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Seamus2626
Seamus2626
Flag of Ireland image

ASKER

Yep, didnt think of that, thanks all!