Formula Help

[Duckyspawn]

Hello all,

 

[bj]

if you want the 1 to be replaced with 35 in the same cell, you will need a
macro to do so.
if you want to have a different Cell show 35 when you enter a 1 into a given
cell, the try Vlookup().

More information please

 

[Duckyspawn]

I want the 35 to show in a f differnet cell when I enter 1 in a given cell. I
have tried Vlookup and am not having much luck due to my lack of familiarity
with it. Can you provide the basic formula to get started?

 

[Dave Peterson]

Say that table is on Sheet2 in columns A and B--and you're typing the number in
Sheet1 A1.

Then you could use this in B1 to get that factor back:

=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

 

[Duckyspawn]

Dave, thanks. The site you provided was perfect!

Say that table is on Sheet2 in columns A and B--and you're typing the number in
Sheet1 A1.

Then you could use this in B1 to get that factor back:

=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))