"Russ311" <Russ311@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:19F444E1-C205-4496-8A67-BE4A8EDA2D93@xxxxxxxxxxxxxxxx > I'm trying to make the comments for a cell more specific by doing a lookup
> e.g I may put a product code into a cell and want the comment to look for
> that code using vlookup and display the product name. Is that possible ?
Re: copy entire row of data from separate w/s ... You can create a *single* Vlookup formula, which when copied along a row, *across* columns, will *automatically* increment the column index number for you, so that you can easily return those 21 columns of data. ..."steph" wrote in message ... >>> once the product code is selected, i'd like excel to lookup the row ... >>> index/match formula but it only returns one cell value at a time. ... (microsoft.public.excel.misc)
Re: Number format based on number format of another cell in another workbook ... Thoug i did not understand fully when exactly you want to format the cell,... I assume that if the VLOOKUP succeeds you want to format that 5 column, ... > columns, product code, product description and 5 columns of numbers. ... (microsoft.public.excel.programming)
RE: Any sugguestion to set up this Calculation? ... You can use VLOOKUP() with IFstatements, ... According to the below sample the 0.65 is a fit rate cell but i need to be ... we will say that sheet has been named CostTableSheet ... I am thinking a way to set up a template for other to use. ... (microsoft.public.excel.worksheet.functions)
RE: Any sugguestion to set up this Calculation? ... I had a table consist of three Country.... on my template I need to choose a correct country. ... Think of VLOOKUP as a single value, and it can be used in formulas just like ... According to the below sample the 0.65 is a fit rate cell but i need to be ... (microsoft.public.excel.worksheet.functions)
RE: Any sugguestion to set up this Calculation? ... I had a table consist of three Country.... on my template I need to choose a correct country. ... Think of VLOOKUP as a single value, and it can be used in formulas just like ... According to the below sample the 0.65 is a fit rate cell but i need to be ... (microsoft.public.excel.worksheet.functions)
