Match Lookup Formula

[robertw477]

I am trying to do a lookup match with a formula. This is not working. I either get a circular error or no data filled in.
The excel file is a file with a worksheet labeled Main and a worksheet labeled Ebay. In column C on the Main sheet there is a price. On some of the records (On the Main sheet) the price shows as 0. Column A on the main sheet is SKU number that is the link in common. On the second worksheet Ebay Column A is SKU and column C is price. I would like the prices copied from column C on Ebay sheet to column C on the main sheet if there is no price listed in that row.


=IF(ISBLANK(C2), VLOOKUP(A2, Ebay!A:C, 3, FALSE), C2)

I appreciate all advice here.

 

[awoohaw]

Are you trying to put that formula in cell C2 (column C) on the main page? If so, you can't do that with a formula.

 

[robertw477]

Are you trying to put that formula in cell C2 (column C) on the main page? If so, you can't do that with a formula.

I did put the formula in that box. Where should I put it? Is the formula itself correct?

 

[awoohaw]

I did put the formula in that box. Where should I put it? Is the formula itself correct?

Can you use the xl2bb add in (link below) to post mini worksheet(s) of your workbook? If not please post well labeled tables.