| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looking at a cell before reffering to a table
Hi I have cells in column "cost" that checks whats in column "item" an checks in a table to find the cost: =VLOOKUP(Item,Q1:R12,2,FALSE), thi works fine but I would like the cost column to look in the column "sold first and if the letter N is in a cell then write 0 in the "cost" cell also if the letter N is not in that cell I would like it to refer t the table. Hope that made sense and somebody can help. Thank -- Skill ----------------------------------------------------------------------- Skills's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=26588 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
looking at a cell before reffering to a table
=if(sold="N",0,VLOOKUP(Item,Q1:R12,2,FALSE))
-- Regards, Tom Ogilvy "Skills" wrote in message ... Hi I have cells in column "cost" that checks whats in column "item" and checks in a table to find the cost: =VLOOKUP(Item,Q1:R12,2,FALSE), this works fine but I would like the cost column to look in the column "sold" first and if the letter N is in a cell then write 0 in the "cost" cell, also if the letter N is not in that cell I would like it to refer to the table. Hope that made sense and somebody can help. Thanks -- Skills ------------------------------------------------------------------------ Skills's Profile: http://www.excelforum.com/member.php...o&userid=14946 View this thread: http://www.excelforum.com/showthread...hreadid=265884 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell, Table, Pivot Table New Styles | Excel Discussion (Misc queries) | |||
| Vlookup Question - Reffering to a column other than the leftmost? | Excel Discussion (Misc queries) | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
| Paste from Word table so that 1 table cell = 1 Excel cell | Excel Discussion (Misc queries) | |||
Linear Mode
