lookups

Hi, I want to look up two variables (discipline and grade) and return the corresponding rate. Elsewhere in the spreadsheet I'm using drop down (data validation) cells to select adiscipline and then a grade and I want the lookup function to automatically return the rate associated with that...

Hi, there is probably a very easy soultion to my problem but i cannot find it! Please help! Basically I have a sheet that has loads of formulas in to gather external data, and i want to 'report' (for want of a better word) on various data for specific departments. So, Sheet (A) contains the...

A LITTLE BACKGROUND INFO We are currently converting mortgage statements that come to us as scanned PDFs. These statements come from over 100 municipalities across Canada. There are over 70 variations as the statements are created using different pieces of software. As a result, a unique...

Hi, I am struggling with this one. Can any of you geniuses out there help? Thank you... <table x:str="" style="border-collapse: collapse; width: 393pt;" width="523" border="0" cellpadding="0" cellspacing="0"><col style="width: 55pt;" width="73"> <col style="width: 48pt;" span="2" width="64">...

I'm not sure how to phrase this for a proper search (the past few haven't worked). I have a situation similar to this one:EXAMPLE for...

I am trying to to have a sheet come up from a pull down, not using valadation, the valadation qption just does not organize text at all and is very small. I will be using LOOKUP based on the selection made on the sheet that is pulled up to insert values based on the selection...

Hi there I have 2 arrays, and I need to test whether any of the values in array A (cells A2:A7) occur in array B (Column H:H on a different worksheet). All I need to return is a basic "yes" or "no", but I'd rather a neat way of doing this rather than doing 5 separate lookups for each of the...