I have a master worksheet which is populated by data from other worksheets. I use vlookup to do this.
This is sort of a total sales spreadsheet. The Master worksheets will show how will a product has sold in certain markets. Each of the sub-worksheets will represent data in these markets.
So I'm using VLOOKUP to scan each data worksheet, and if there is a header that matches a header on the master worksheet, then it's supposed to take the dollar figure next to it and plop it into the master worksheet.
The equation looks like this:
=VLOOKUP($C6,'test'!$B:G,3,FALSE)
This works just fine. It looks on worksheet 'test', find the row which matches the text in cell C6 in the master sheet, then pulls the dollar figure next to it.
However, sometimes there will be no data elements in the worksheet that match the text in cell C6.
For example, say cell C6 on the master worksheet says ' BOB,' . If worksheet 'test' has a cell that says 'BOB' and we sold $10,000 worth of untis in 'BOB,' then the master spreadsheet will reflect that.
However, if the worksheet 'test' does not have any cells that say BOB, I get a #N/A error in the master spreadsheet. This may hapen because while we track sales for BOB, there may not have been any sales for BOB this quarter.
I was trying to work up an IF statement so that if there is no value, it would just put in the number 0.
=IF(VLOOKUP($C4,'test'!$B:G,3,FALSE)<>"",VLOOKUP($C4,'28days'!$B:G,3,FALSE),0)
But this doesn't work either.
Am I making any sense? Does anyone have any ideas on how to resolve this?
This is sort of a total sales spreadsheet. The Master worksheets will show how will a product has sold in certain markets. Each of the sub-worksheets will represent data in these markets.
So I'm using VLOOKUP to scan each data worksheet, and if there is a header that matches a header on the master worksheet, then it's supposed to take the dollar figure next to it and plop it into the master worksheet.
The equation looks like this:
=VLOOKUP($C6,'test'!$B:G,3,FALSE)
This works just fine. It looks on worksheet 'test', find the row which matches the text in cell C6 in the master sheet, then pulls the dollar figure next to it.
However, sometimes there will be no data elements in the worksheet that match the text in cell C6.
For example, say cell C6 on the master worksheet says ' BOB,' . If worksheet 'test' has a cell that says 'BOB' and we sold $10,000 worth of untis in 'BOB,' then the master spreadsheet will reflect that.
However, if the worksheet 'test' does not have any cells that say BOB, I get a #N/A error in the master spreadsheet. This may hapen because while we track sales for BOB, there may not have been any sales for BOB this quarter.
I was trying to work up an IF statement so that if there is no value, it would just put in the number 0.
=IF(VLOOKUP($C4,'test'!$B:G,3,FALSE)<>"",VLOOKUP($C4,'28days'!$B:G,3,FALSE),0)
But this doesn't work either.
Am I making any sense? Does anyone have any ideas on how to resolve this?