lookup formula

A2 contains a forumula that returns a value of 12345. of course when you select on A2 it shows the forumula that creates that value. in b2 I want to add a formula that looks at the final value of A2 (12345) looks for it on a list of values in column c if result is N/A (bc value is not on C) -...

I have a spreadseet where I am tracking several thousand rows of purchases and it will continuously grow. I have a sort of run on Nested If statement and I'm wondering if there is a way to make this cleaner. Here it is: =IF(G2373="On...

I've had a look at this for a while and can't find a solution PLEASE HELP! I have a list of securities with unique IDs, for example... ID Sec_Name 123-00 Security ABC 456-00 Security DEF 789-00 Security GHI On a seperate sheet I have a list of groups. These groups list all...

Hi Guys I have a small problem with a lookup formula. I am trying to perform a lookup formula that will look in cells B5:G5 for the number 2 which in turn will return the value I have placed beside the number 2 in my lookup table which is in Cells I2:J5. Can you please help. Thanks In Advance...

In context, imagine you have a table with Columns (A) City, (B) State, and (C) Population. I'm familiar with arrays like this to return the population for each city/state combination: {=SUM(IF((CityA=$A$Column)*(StateB=$B$Column),$C$Column,"Error"))} When Columns A and B are unique...

Hello Everyone, I'm not that good at Excel and I desperately need to do something that is a bit beyond me, so would be truly grateful for the help of any Excel Geniuses out there.... Basically I have two tabs on a spreadsheet. One tab contains an items unique reference number and some other...

Hello, I have a problem I would like to see if it's able to be solved with a formula... and I'm quite sure there is, but I'm not just sure how to get there. I've thought about using something like the Index/Match formula, but nothing has come to mind. I have a table of, but not limited to...

Hello, I really need some help here, and I was hoping that someone might be able to answer my formula question please (I've been trying to figure this out for 4 hours, and I know one of you experts will have it solved in 2 minutes :)) Ok, so I have a spreadsheet with this layout (see below)...

Hi, I have a table that shows apartment numbers in column 1 (in ascending order), and a parking space number in column 2, if a parking space has been assigned to the tenant in that apartment. The parking assignments could change any day. I am trying to create a new table under a new tab, where...

I have a single column which I list all the door sizes offered. Doors are listed by width and then height. Example of Door Sizes Offered Column (info for clarity) 3068 (3'-0" x 6'-8") 3070 (3'-0" x 7'-0") 4040 (4'-0" x 4'-0") 4068 (4'-0" x 6'-8") 4070 (4'-0" x 7'-0") 5068 (5'-0" x 6'-8") 5070...

I would like to write a formula that looks at the last month with a percent value greater than zero, then return the percent value in a specific cell. In the example below I want to display 85.0% in the cell. It should update each time data is entered for the following month. Here is the...

I am trying (without success) to update a downloaded spreadsheet. I have 2 columns of info - one with codes and another with prices. i require to change the prices from a second spreadsheet containing the same (but not quite) codes and new prices. some of the codes do not exist on the new...

I am trying to create a complex spreadsheet for cricket scores. The first problem I have is I need to know a high score after I have used the CONCATENATE formula (I have combined the scores with either nothing or a *). I have converted the matrix to number format and I understand that this...

I am creating a userform that I hope to use to create a quick quotation packagei have worked out most of the userform and it now works fine i just have one small thing that i need help with The userform that i have created has a combobox which is used to show part numbers from my spreadsheet. I...

Heloo all i need a quick solution to a very anoying problem...... i have i long sheet full of details as follows: a1 = name b1 = department c1 = school qualifications d1 = diplomas e1 = certificates f1 = further........ and so on.... with about 800 people in this sheet at any one time i don't...

I have BSU's that share a prefix in this format- 7HP, 7AP, and have some letters after that for different departments. Then I have indepenedent departments with no client prefix in this format- 2HO, 1HO,ZHO, etc. I want to make an IF statement with multiple wildcards, something like...

Hi everyone! I got this function I found on the internet and I use it to look up a value in a table based on two conditions, kind of a sumproduct for vba... However, now I would require it to work with an additional condition... So does somebody of you know how the following function works...

Please help! I need a formula that can lookup (and match the due date to the column heading weekday of top row in a worksheet calendar) a store in a data table and return it's product shipping date & time in the relevant column in a worksheet calendar. Data Table: In the data table, the...

I need a formula that can lookup (and match the due date to the column heading weekday of top row in a worksheet calendar) a store in a data table and return it's product shipping date & time in the relevant column in a worksheet calendar. Data Table: In the data table, the store numbers...

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 12"><meta name="Originator" content="Microsoft Word 12"><link rel="File-List"...