Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

In Sheet 1, do a VLOOKUP on Sheet2:


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

Your Answer


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.