Solved The sum for looking up various numbers across two sheets

July 4, 2012 at 01:58:55
Specs: Windows XP
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!!!!


See More: The sum for looking up various numbers across two sheets

Report •

#1
July 4, 2012 at 06:51:23
✔ Best Answer
"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.


Report •
Related Solutions


Ask Question