| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks,I was unaware of this or the hlookup function.
"Paul B" wrote: Drum626, have a look at vlookup in help, I think it will do what you want to do -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Drum6226" wrote in message ... I am trying to creat a price sheet such that when any part number is shown it is assigned the proper price. ie Part No. Price XY $5.50 Ab $2.20 I've tried this with the if function but always come up with #Value! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Date & Time | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Hybrid Mode
