Vlookup Question

[Ewing25]

I have 2 workbooks one named "Expense Pivot (April 08)" and another called
"Detail05-06-08(1)"

Somehow i want it to automatically fill in Column B in "Detail05-06-08(1)"
according to what it has in "Expense Pivot (April 08)". depending on the
values in column A in both WBs.

I think VLOOKUP can do this but im not sure how.

Thanks!

 

[Max]

Presume you meant sheets

One way via index/match

In Detail05-06-08(1),
Put in say, B2:
=INDEX('Expense Pivot (April 08)'!E:E,MATCH(A2,'Expense Pivot (April
08)'!A:A,0))
Copy down to return results from Expense Pivot (April 08)'s col E

Adapt this part: INDEX('Expense Pivot (April 08)'!E:E ...
to suit the col that you want to return