Hi everyone,

I was hoping someone could help me out or point me in the right direction

I want to make a UDF, call it "Car".

I would type "=car" in any cell and define the variable, say "BMW". It would then look for "BMW" in another spreadsheet and return the corresponding value in another column (in essence a vlookup). Does this make sense?

Can anyone help me out or point me in the right direction?

Thanks!