Solved: common problem needing a little direction

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.

Lex.Luthor

Thread Starter
Joined
Jun 28, 2008
Messages
263
I hope that this has been answered several times before. I am using MS 2007 excel. Attached is a sample. Here is what I want to do:

In the second sheet I want to be able to search all of the data of sheet 1 in the part column, find the matching information and entering the cost into the second sheet . Rather than using a copy/paste all of the time. I hope that I am able to explain this.

Any and all help on this will be really appreciated.

Thank you very much.
 

Attachments

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,641
Hi Lex,
You could use VLOOKUP but then this only works, as far as I know with text not numbers.
I reatttached your sheet with the VLOOKUP necxt to your column and you see two values retrund because \i changed one to a text string to test.
 

Attachments

Lex.Luthor

Thread Starter
Joined
Jun 28, 2008
Messages
263
Keebellah,

I've looked at the results from what you have tested out and I was thinking that I could use the vlookup function, but I have not that much experiece with vlookup. I was thinking that it coulbe be the vlookup or maybe the "IF" function. This one looks like that you have gotten this one dead on.

I'm giving you a "gold star" on this one :)

Thank you very much.

Marked this one solved!
 
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

Top