I am stumped!! LOL
Posted by Judy on December 23, 2001 4:12 PM
I am trying to create a spreadsheet that has three columns in it as follows: ITEM, POINTS, DESCRIPTION. I want to be able to enter an item number (one of about 100 different items) in the ITEM column, and have the points that relate to that item show up under POINTS and the description of the item show up under DESCRIPTION.
ITEM POINTS DESCRIPTION
A1 30 Stereo Install
F5 60 Under Car Neon
I have (I think so anyway) created a range name for each of those three columns, thinking that I would be able to enter a formula in the POINTS column stating If ITEM="A1",30 but that is not working. I think I may have to use set up a table with all my Item numbers, Point value and descriptions and use the VLOOKUP function or something like that but I really do not know for sure if that is the case! GEEZ I feel so braindead!! LOL
Can anyone spare a few minutes to help me with this? It sure would save me alot of time doing one of those "busy work" reports I have to do!!
Thanks! And have a great Holiday Season!