I’m trying to create a formula in Excel and I am having problems with it - think from previous posts it is a vlookup but can't get this to work as I hoped it would.
In sheet 1 (called raw data (2)) I have lots of cells with data.
In sheet 2 I have some of this data and blank cells. I need to look at sheet 1 column B and see if it matches any cells in Sheet 2 column B. If it does match then I need to take results from sheet 1 columns G to AA and input these into sheet 2 columns E to Y.
I created a vlookup with the formula =VLOOKUP(B3,'RawData (2)'!B2:B6659,7,FALSE) to try to enter the first result into sheet 2 column E. This gives me a N/A result despite my knowing that cell B3 does have a matching result in sheet 1.