Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using and IF functio between 2 worksheets.
On one work sheet I have 3 columns listing an item #, the product description
& the price. On the other worksheet is a sales bill where products can be listed and tallied. Is there an IF formula that allows me to type in an item number on the sales bill and have the product description and Price automatically appear in the adjacent 2 cells. This would be a function I want to repeat down the Sales Bill until the customer is done selecting Items. This function, If possible, would save time in retyping Item descriptions and/or using the cut/copy cell feature. |