You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
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
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
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.
D'oh! Thank you, Barry
Already sorted, but thank you.
VLOOKUP - Arrrrgh!
