MrExcel Publishing
Your One Stop for Excel Tips & Solutions

look up values?

Posted by Frank on January 28, 2002 4:31 PM


Is there a function in Excel, like sumif, that would get information in row or column when specific criteria comes up.

For Example:

Any time apple or 333 comes up in column A. I would like to get information from rows to the left or right of criteria.

Thank you,


Posted by Juan Pablo G. on January 28, 2002 5:41 PM

Look at VLOOKUP worksheet function. Also, INDEX/MATCH combinations.

Juan Pablo G.