EXCEL x-reference

sam - Jan 30, 2009 at 11:38 AM
 sam - Jan 30, 2009 at 01:36 PM
Hi there friends,

I have a excel spread sheet that i am using to keep track of sales.

What i need is a formula or function that will check a list of companies and return their tax code.

If i enter "company name" into Col1, Col2 should be filled automaticly by retrieving the tax code from the list of companies.

Thank you in advance for any assistance!

1 reply

Hello Sam

Please send the file and let me know what exacty you need.
I will work on it and send it back to you.


i found the answers on the forum just after i posted, HOWEVER,

I need to be able to copy and paste the formula down a column of 1000 without the entire forumula changing.

the current formula is
=VLOOKUP(A2,Sheet2!A2:C1000, 2, FALSE)

however when i copy and paste it to the next cell it becomes
=VLOOKUP(A3,Sheet2!A3:C1001, 2, FALSE)

I need it to become
=VLOOKUP(A3,Sheet2!A2:C1000, 2, FALSE)

there must be a special paste function built into excel? i hope.

thank you for your response & time.
ok, after some more digging, i found the answer.

if i put =VLOOKUP(A3,777, 2, FALSE) in the cell
copy it down, then do a find & replace for 777, replace with Sheet2!A2:C1000