Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I'm trying to look-up a value in sheet 2 from a number on a row in sheet one: it looks like this:

Sheet 1:

Row4 Number of units    0   5   25  10  15

And sheet 2:

column a column b

1   
2   
3   
4   
5        10.00%
6        11.00%
7        12.00%
8        13.00%
9        14.00%
share|improve this question
    
You want to search for 5 in sheet 2? –  Jacob Jan Tuinstra Aug 31 '13 at 17:48
add comment

1 Answer 1

In Sheet 1, do a VLOOKUP on Sheet2:

=VLOOKUP(A4,Sheet2!$A$1:$B$9,2)

where A4 is the value you're looking up in the table $A$1:$B$9 on Sheet2, and return the value in column 2 of the row you find the value of A4 in.

Do this for every value in Sheet 1.

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.