Solved: Using Calc

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

svmali84

Thread Starter
Joined
Sep 24, 2008
Messages
2
Hi All,
I am new to open office calc.My spreadsheet is like the below format

ID NAME

1 Bill

2 Sanc

35 Rivek

1 Bill

Now what i wanted is that when i type "1" then "Bill" Should come automatically.i.e.If that ID is already present then the name should come automatically.

Please help me how can I do this in Calc Spreadsheet?
Also can i do the same thing if my lookup sheet is in another worksheet?
 
Joined
Jul 2, 2005
Messages
880
Are you wanting a VLookup? Not sure exactly from your description, but that could do what you want

Something like this-- I used sheet two for my list of customers- (In my case I typed the name and it provided the customer number)
=VLOOKUP(A2;customer;2)

the formula looks at what you type into A2 then compares it with the customer list to see if the name in A2 is a match- then prints out the information in column 2 (customer number). NOTE: I defined customer file as the area on sheet 2- A1:B67 (that is the lookup file) Also note: Oo_O uses semi-colons to separate arguments rather than commas.

letchworth
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top