VLOOKUP - Arrrrgh!

Question

cooperscuba Author

Level 1

8 points

VLOOKUP - Arrrrgh!

Hi

I'm trying to return the value in column 2 (Specific Gravity) to a another sheet (Template - 1 Ingredient)

And it returns an error (The formula contains an invalid reference.)

However, if I change the return-column value from 2 to 1, it returns the correct field's content.

Anyone have any suggestions why this is happening?

MacBook Pro 13", macOS 10.14

Posted on Jul 18, 2019 2:16 AM

Reply

Answer 1

Yellowbox

Level 7

21,939 points

Jul 18, 2019 2:45 AM in response to cooperscuba

Hi cooperscuba,

I am not sure of your aim, but see if this works for you:

=VLOOKUP(A2,Table 1::A:B,2)

Regards,

Ian.

Reply

Answer 2

Barry

Level 9

60,023 points

Jul 18, 2019 2:41 AM in response to cooperscuba

You have stated in the formula that the column "Ingredient Description" is the only column in the VLOOKUP table. There is no 'column 2', so telling VLOOKUP to return the value from the 2nd column of this one-column table returns the error message you see.

Regards,

Barry

Reply