Previous Topic Next Topic

EXCEL x-reference

Solved/Closed
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!
Related:

1 response

Answer 1 / 1
Austin
Jan 30, 2009 at 11:56 AM
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.

Thanks

Austin
0
sam
Jan 30, 2009 at 12:38 PM
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.
0
sam > sam
Jan 30, 2009 at 01:36 PM
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


hehe.
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses