Problem how to use VLOOKUP!!

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

simple issue which I am sure someone here will know the answer to.

Using Excel 2007, I am attempting the following:

basically I have 2 reference columns, A is account name, B is account No

In another worksheet, when I populate a cell with the account No, I want the next cell along to be filled with the account name.

cannot get this to work and its driving me nuts!

Thanks in advance.

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Whats the formula your using?

 

Si,

its

=VLOOKUP(A7,B7,C7)

cheers

 

should probably add that the reference colums are on one sworkheet, with the actual working spreadsheet on another worksheet, so I am referencing the colums on one worksheet, in another (that makes no sense I understand!)

 

Shouldn't it Look something like this

=VLOOKUP(L1,A1:C5,1,FALSE)


[added]
if your data is on another worksheet then your range would look like "Data!A2:C5" with "Data" being the worksheet name

 

Have a look at this one

 

thanks for this Thomas but I cannot see what should be happening?
Granted, i did not label my worksheets accordingly for s start

 

View attachment The LOOKUP Function - Delegate Handout.pdf

This is a bit old now but may help you work it out.

 

thanks for the assistance guys

 

In the example the "table_array" was on the second worksheet called Data(A1:B4), on the Lookup Worksheet A1 held the VLOOKUP function and B1 was the "lookup_value"

B1 = 1 and A1 shows AC1

if you change B1(between 1-4) this will update the value in A1