Need help with If Function between sheets

[pearl11]

I am trying to simplify having to input fixed information.

I have information on two excel sheets/tabs

One sheet is where i want to input data

the other sheet is where i want it to grab the info.

So if I put in 3 in A1, it will look on the second sheet and grab a number from B3 and place this number in A2 (on the first sheet).

If I put in 2 in A1, it will look on the second sheet and grab a number from B2 and place this number in A2 (on the first sheet).

I was able to figure out how to it for one number, but if you ask other numbers it doesn't work.

=IF(A1=3,Sheet2!B3)

so that formula works for the number 3. what if I put in the number 2 or 9 or 211?

Any suggestions?

 

[pearl11]

thanks to you I won't need to get a coffee after all.

 

[MrKowz]

Well, that's no reason to NOT get coffee!

Also, be sure to check the Excel help files on formulas you are unfamiliar with. They usually have decent explanations to answer basic questions.

 

[pearl11]

=VLOOKUP(A1,Sheet2!A:B,2,0)

I really want to use this formula (and I thought I figured it out but i didn't)
instead of entering the number from A1 on Sheet 1 (my original question)
I am entering the number from AB4 on sheet 1

the information on the second sheet is coming from B3

I am getting an unknown range error

So on the first sheet AB4 (AB5 and so on) is where you plug in a number between 1 to 200 which is the weight. When this number is put in, it will reference the second sheet which has numbers in the A column 1-200.
If it is AB4 (on the first sheet) is 5, it will look in the A column (on the second sheet) for 5 and then give me the number (on the second sheet) in B7 cell, then put this number in AG4 (on the first sheet).

Same formula but for some reason I am getting unknown range error

First Sheet
AB Column AG Column
Weight Number put in These number would draw from
Can start entering in AB4 (and so) column B second page




Second sheet

Column A Column B
1 5
2 5.5
3 6
4 6.5
5 7

 

[pearl11]

 

[MrKowz]

Your screenshots did not post correctly.

It might be the way the sheet is being called, what are the exact names of the sheets you are using? And which of those sheets are you trying to find the data on?

 

[pearl11]

http://img153.imageshack.us/img153/4014/sheet2.png

http://img375.imageshack.us/img375/5729/sheet1t.png

 

[pearl11]

ok I got it to read from different pages

now how do I get it to read on the second sheet ie sheet2 from column C instead of column b?

would that be =VLOOKUP(AB12,Shipping!A:C,2,0)?

 

[pearl11]

the exact name of sheet2 is shipping

 

[pearl11]

http://img703.imageshack.us/img703/9436/entirepicture.png

this image should explain everything clearly

 

[MrKowz]

Ahh - I see now.

=VLOOKUP(AB12,Shipping!A:C,3,0)

You needed to tell the LOOKUP function to look at columns A through C (the Shipping!A:C part), and then tell it to look at the third column in that array (A is the first column, B is the second, C is the third)

Use these three formulas to get your Cost A, Cost B, and Cost C respectively:

=VLOOKUP(AB12,Shipping!A:D,2,0)
=VLOOKUP(AB12,Shipping!A:D,3,0)
=VLOOKUP(AB12,Shipping!A:D,4,0)