I need to use the VLOOKUP formula to pull data from a range of cells on another sheet in the same workbook.
Can anyone give me the exact syntax to do this. My workbook name is Estimate.xls and the Worksheet name is PriceList.Here is my formula which does not work! Thanks.
=IF(G313=0,"-",VLOOKUP(G313,PriceList!A1:D5000,4,0))
Can anyone give me the exact syntax to do this. My workbook name is Estimate.xls and the Worksheet name is PriceList.Here is my formula which does not work! Thanks.
=IF(G313=0,"-",VLOOKUP(G313,PriceList!A1:D5000,4,0))