Returning A Number Against Specific Text

[Streaky]

apologies for the thread title, I'll hopefully explain a little better here.

I've got four possible entries in column E that relate to the types of 'time off' my staff can have (Weekday Full, Weekday Half, Friday Full and Friday Half). I want to enable it so that when I select one of those 4 drop down options that it returns a number in column F that equals the amount of time off in hours. The breakdown for what I want to appear in relation to each option is here:

Weekday Full - 7.5
Weekday Half - 4
Friday Full - 7
Friday Half - 3.5

I would usually just forget about the description and list the hours but I need to simplify it for new starters to understand.

I can get it working for one entry using =IF(ISERROR(SEARCH("Weekday Full",E2)),2,7.5) but I need to get the formula looking for the other 3 options and subsequent number values, any ideas

[daffodil11]

Instead of trying to smoosh all the possible outputs in a single formula, instead you could simplify it by placing the possible entries in short table.

Imagine Sheet2 A1: Time Off, B1: Time, A2: Weekday Full, B2: 4, etc.

Now back in your thing thing:

=VLOOKUP(E2,Sheet2!$A$2:$B$5,2,0)

[Jonmo1]

Try

=IF(LEFT(E2,3)="Fri",3.5,4)+(RIGHT(E2,4)="Full")*3.5

[AlKey]

With table created in columns G2:H5 and formula in F2

=LOOKUP(2^15,SEARCH(G2,$G$2:$G$5),$H$2:$H$5)

Row\Col	E	F	G	H
1			Table
2	Weekday Full	7.5	Weekday Full	7.5
3	Weekday Half	4	Weekday Half	4
4	Friday Full	7	Friday Full	7
5	Friday Half	3.5	Friday Half	3.5

[Streaky]

both of those work well, I actually used a VLOOKUP for something similar the other day but it completely didn't occur to me to do it that way.

Thanks both, rep added