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]

and if there is also a cost D, cost E and cost F
in column J, column K, column L?

 

[MrKowz]

Then extend out the lookup range to include more columns, and adjust the lookup column.

 

[pearl11]

and if there is also a cost D, cost E and cost F
in column J, column K, column L

that would make the formulas?

=VLOOKUP(AB12,Shipping!A:L,6,0)
=VLOOKUP(AB12,Shipping!A:L,7,0)
=VLOOKUP(AB12,Shipping!A:L,8,0)

 

[MrKowz]

Your column indexes arent correct.

Think of it this way, you have it looking at ranges A through L.

Their column index would be

A=1
B=2
C=3
D=4
E=5
F=6
G=7
H=8
I=9
J=10
K=11
L=12

Now, say you are using VLOOKUP somewhere else, and your lookup range is instead columns M:R. That would make the column indexes be:

M=1
N=2
O=3
P=4
Q=5
R=6

 

[pearl11]

thanks so much