looking at a cell before reffering to a table

  • Thread starter Thread starter Skills
  • Start date Start date
S

Skills

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
reffering another cell value which contains RAND() 0
Is there a macro equivalent to cell function SumProduct? 4
Item Count vs Item Cost 1
Copying and Adding Values 1
Select range from ActiveCell do to Lastcell 5
Copying a formula to a range 2
Workbook code to Module Code 4

Back
Top