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 have a sheet where I want to use a formula to refer to a field on another sheet. I do not know the exact cell address, but I know it's the cell right next to the cell where it says "Niels Brinch".

How do I reference the cell?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

If you know which columns both "Niels Brinch" and the cell you're looking for are in, then you can achieve this with a VLOOKUP.

Your formula would include something like

=VLOOKUP("Niels Brinch", A1:B20, 2, false)

In this case I'm assuming the name appears in column A and the cell you're looking for is in column B and that you only have 20 rows of data. If that isn't the case, you'd need to adjust the second parts of the function. Replace the range with a table containing what you're looking for. The column with the name should be the first column in this range for the lookup to work.

share|improve this answer
    
And then I refer to the other sheet before A1? –  Niels Brinch Feb 8 '13 at 14:56
    
Yes. Sorry the range would be 'Sheet1!A1:B20' or whatever the appropriate range and sheet name would be. –  aelfric5578 Feb 8 '13 at 15:24
    
Nicely done. It works perfectly. Thanks. –  Niels Brinch Feb 11 '13 at 8:03

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.