View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
 
Posts: 207
Default IF function help

If you have to return BULSY, in the formula write "BULSY"

Hope this helps.

"bulsy" wrote in message
...
I have a table with names going down the column, and then numbers in the 7
columns to the side. Below that, I created another column of all the
possible numbers. I then created a conditional to look through each
number
column above and see if it will match the corresonding number of the cell
I
am in below. If it matches, I need to it to display the name that
corresponds to the number match. However, it seems that it wont display
the
name for some reason. I know the formula is right because if I were to
manipulate it so it would display a number instead, this works. It seems
that the problem is in displaying the name as it's not a number. Anyone
know
an additional function I need to insert to get the name displayed?