Hello,
As posted in the introduction thread, I am a previous Excel user who has forgotten everything now, and need some help and patience, please. This is probably very simple...
I need to create a sheet that adds numbers associated with two text title columns. Here are some screen shots that will clarify (hopefully)...
excel01.JPG
excel02.JPG
The object:
When the program finds the word "RED" in column "A", it must look in column "B" for the word "RED", and add the numbers in column "C" on the associated rows.
Column "D" performs a MATCH() function that gives an offset to the first occurrence of "RED" in column "B".
For example;
A4 contains "RED". The next occurrence of "RED" in column "B" is four cells down (inclusive), as determined by MATCH() in column "D".
excel03.JPG
I use the LOOKUP() function to find when "RED" occurs in column "B" by its MATCH() result being equal to one (1) in column "D". Then it add the numbers in column "C".
As can be seen, it is working to an extent, but the conditioning of the formula by the IF() statement completely fails to do its job. And further to this, the procedure fails on A8, where it should look up B11, and add 47 + 74 in column "C".
I'm having trouble understanding why this is not working. Any help appreciated. Thanks in advance.
Bookmarks