Look up data in sheet 2 using sheet 1

[Skiman]

Hi guys,

I'm trying to be able to input a number in sheet 1 and have it display the data associated with that number. I've attached an example.

If I input 60 in A1 on sheet 1, I want it to display the data associated with 60 on sheet 2. In this example, the result is f.

Can you help?

Thanks

APBook1 lookup.xls

[MarvinP]

Hi skiman,

In B1 on sheet 1 put this formula.
=VLOOKUP(A1,Sheet2!$A$1:$B$14,2,FALSE)

[Skiman]

Thanks Marvin

I want to be able to change the number in sheet 1 to pull the associated data from sheet 2. Where in the formula would I do that?

Skiman

[DGagnon]

The formula provided by Marvin will work in that way, you just need to put that formula in a cell on Sheet 1. it is refrencing cell A1 to find out what data to display.

[Skiman]

Thanks. I'll try that. Thanks again for your time yesterday. I changed some things around to see if it was easier for me to explain.

[Skiman]

I'm just not sure where I can change the search number. I'd want to know where to put 10 to get a, 20 to get b and so on. That is where I am struggling. Would it be too much trouble to explain that? Sorry for the rookie questions. I'm sure this is pretty boring for you guys. I'm just not sure what to do.

AP Skiman

[DGagnon]

put the provided formula in cell B2

then just change the value in A1.

[Skiman]

Thanks. Its working for me. I appreciate your time DGagnon and MarvinP

[Skiman]

That's perfect. Thanks!!