Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer 1

Are you sure that it’s giving you #N/A and not #REF?  Because #REF is the expected result of the fact that your “table_array” (the second argument to VLOOKUP) doesn’t include the data that you want to retrieve, e.g.,

=VLOOKUP(B3, 'RawData (2)'!B2:AA6659, 7, FALSE)

Also, if you want to get the value from column G, the third argment should be 6, as this is counted relative to the B column (i.e., column B is number 1).  Also, you’ll want to make the row and column numbers absolute ($B3, $B$2, and $AA$6659) before you try to fill Sheet2 with this formula.

Did you deliberately mis-match the row numbers (2 ≠ 3)?

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.