Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
VLOOKUP tables
Name: puckhead1213 Date: September 13, 2005 at 14:44:01 Pacific OS: Win2000 PRO CPU/Ram: PIII/ 128MB RAM
Comment:
I am about to create a table to use in a vlookup formula. The table will consist of 300 different numbers in the left column. The right column will only have 6 different numbers. For example: Numbers 200-299 will all have the same result. 300-399 will have the same result as well etc... My question is. Do I have to type in each number individually in my table or is there a short cut to entering numbers in a range,ie... 200-299. I hope I worded this clear enough. Any help would save my bacon !
Summary: re: only ER and EP, without any additions, are allowed. Who says? You're building the spreadsheet aren't you? Add the rows for EP (Heat) etc. to your lookup table and add EP (Heat) etc. to your drop ...
Summary: Hope somebody can help. This relates to a pricing spreadsheet I have a price list for a software license that varies depending on the qty of licenses. 1-4 cost 1000; 5-9 cost 800 and so on. I have a c...
Summary: Hope someone can assist with a problem I have never previously encountered. I am trying to add a column to a spreadsheet with the formula '=0&<Cell details', which returns the contents of the chose...
0 
Outlook,slow in mails wt ...
