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

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