| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula help please
scott wrote:
Frank. Just wanted to let you know that I had made a small mistake in entering your formula. When I highlighed the range cells I forgot to include column a, so I had $b$6:$d8 instead of $a$6:$8. For some reason it seemed logical for me to do it this way since I already entered column a as the look up column, but I guess it needs to be included here also. So I made this adjustment and it worked! Thanks again. Scott Just curious, why do you only put one dollar sign in front of d8, rather than $d$8? quite simple. I just forgot it :-) Frank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Threaded Mode
