I have a sheet with patient identifiable numbers in it - I want to see if these patients are in another sheet with their identifiable numbers - What is the sum that I need to put in? Many thanks - I have brain freeze!!!!

"What is the sum that I need to put in?""SUM" is a function used to add values. I think you meant to ask:

"What is the function I need to put in?"or

"What is the formula I need to put in?"Excel has a number of "look up" functions that might work for you such as VLOOKUP and MATCH, amongst others. You should review the Help files on them and see which one fits your needs. You can also use Google for more information.

Without knowing how your data is laid out, we can't tell you which function will work best for you. Perhaps if you posted some example data we could help more.

Before posting any data in this forum, please click on the following line and read the instructions found via that link.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History