IF - returns name error

  • Thread starter Thread starter Alan Davies
  • Start date Start date
A

Alan Davies

I want to use an IF statment in a spreadsheet as follows

Column I cells are Validated as Lists for input

Column K is a value that is associated with Column I

I want Column P to show me column K's value if Colmun I matches a certain
selection from the list:

When I input the statement:
=IF(I2=ABCD,K2,0) I get an error of #Name? in P2

Can anyone explian why, and help me correct this please
TIA
 
Hi
Try this,

=IF(I2="ABCD",K2,0)

With text you have to inclose it in qutation marks otherwise Excel
thinks it is a name in the sheet and can't find it.

Regards,
Bondi
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index and Match 8
With F1 value, look at A, if match or partial match return B 5
Unique Random List 13
IF statements with multiple criteria 2
Using ISNA on more than one column within an If Function 2
IF formula help? 5
Match Text return a value from the row 2
Nested if function 13

Back
Top