I'm a database geek, but my Excel experience is extremely limited and I cannot get the syntax working properly on a VLookUp() function call. It might have something to do with a space in a worksheet name of the first worksheet.
I have two worksheets in a workbook. The first is titled 'Gas 092013', the other is 'RAD_Gas_0913'.
I have inserted a column (P) into RAD_GAS_0913 and want to pull in the value from column J in 'Gas 092013' where the value in Column B matches column B in 'Rad_Gas_0913'.
=IF(ISNA(VLOOKUP(B3,'Gas 092013'!$B:$J,10,FALSE)), "not found", VLOOKUP(B3,'Gas 092013'!$B:$J,10,FALSE))
If it makes a difference, the "data" in 'RAD_Gas_0913' starts on row 2 of the spreadsheet, but in 'Gas 092013', the data starts on row 9 and ends on row 605.