Vlookup?

[rednews07]

I have a company and I am trying to clean up my Excel monthl
expendtiures. I have two seperate excel sheets of expenditures and wan
to be able to link them together so I can plug a number into one an
have it automatically update to the other. I believe I need to someho
use a V lookup function but am having trouble piecing it together. Ho
can I plug into A and have it automatically update B? Thanks

 

[lhkittle]

I have a company and I am trying to clean up my Excel monthly

expendtiures. I have two seperate excel sheets of expenditures and want

to be able to link them together so I can plug a number into one and

have it automatically update to the other. I believe I need to somehow

use a V lookup function but am having trouble piecing it together. How

can I plug into A and have it automatically update B? Thanks!

rednews07

Well, the short answer would be something like this.

In B1 =VLOOKUP(A1,F1:G100,2,O)

Where:
A1 is what you want to lookup and is a unique value somewhere in column F1.
G1:G100 is a list of 'stuff' that you want to have returned to the cell B1.

The 2 represents the second column in the Lookup_Array F1:G100.
The 0 means you want to find an Exact match of what is in A1.

There are many ways to use Vlookup, depending on what you need is and the data layout.

Regards,
Howard