Using the IF function

[dwalters]

I have a spreadsheet where a column of cells can have 4 different entries - In e.g. AC3 I want to say if the info in A3 says UK put £550.00 if it says BAG put £450.00 if it says CIV put £850.00 and if it says RN put £850.00 - grateful for any help, thanks in advance

[ben_hensel]

This is really a better fit for a CASE function than an IF function.

Well, there's no built-in CASE, so just simulate it with INDEX(MATCH) instead.

=INDEX(output_range, MATCH(value, input_range, 0))

Then you can either build a table of input+output ranges for it to look at (probably best solution), or just imbed the ranges as arrays inside the function like:

A3 =INDEX({550, 450, 850, 850}, MATCH(AC3, {"UK", "BAG", "CIV", "RN"}, 0))