Combined IF and LOOKUP functions - Help please!

you can use a lookup or an IF

=vlookup(A1, Range with description, 2, false)

perhaps if you provide a sample spreadsheet - we can add the code

or in C1 add

=LOOKUP(A1,{1,2,3,4,5;"poor","Very poor","C","D"})

not as flexible as a table using vlookup or index match - as you can change the return values in the table , rather than change formulas

=CHOOSE(H10,"Good","Bad","Wose")

Where h10 will be 1 to 3

Hi Guys,

Many thanks for your replies.

Attached is an example spread sheet for what I am trying to do.

When I select a 'Score Awarded' from the drop down list in Cell H12 on Sheet 2, I want the box at Cell A16 (Sheet 2) to automatically populate with the Award Criteria 1 Justification outlined from Cells B3 - B8 on Sheet 1. e.g. if Cell H12 = 2 then Cell A16 looks up Cell B5 on Sheet 1.

Help is much appreciated.

Cheers

Daithi

no sample attached

Attached now.

Apologies.

your using a few merged sells so not sure where H2 is or A16 as its all merged

BUT you can use vlookup

=vlookup( cell with the number in, Sheet1!A3:B8, 2, false)
change the sheet1 to the actual nake used in the sheet - if you have spaces then use '

'sheet with spaces'!A3:B8

=vlookup( H2, 'Input Parameters'!A3:B8, 2, false)

yep, thats what the formula was trying to do

Look down column A3:A8 and match the value 0-5 and then look at the column B and return the adjacent value
for example
in A6 you have the number 3
and B6 has Good - Good response that demonstrates basic knowledge and understanding of client's objectives, and gives confidence that supplier has adoped sufficent approaches

and so if you had 3 in the cell H2
in the Cell A16 then with the formula
it would look up 3 and display the text in B6

but your sample had lots of merged cells and H2 - does not exist as its merged into a2

perhaps you could show the sample and highlight the cell with the dropdown and the cell the result is required

see my sample sheet1
cells A7 and B7

A7 has the drop down - change that and the text appears in b7

I now got it to work.

Thank you so much for your help.

Expect a few more posts in the near future!

your welcome

FYI - merged cells are difficult to get formulas working in

you can format and centre over a range

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here