What function do i use?

  • Thread starter Thread starter motorman2008
  • Start date Start date
M

motorman2008

I am trying to pull information from one work sheet to another.

on one work sheet in colomn A there are several names and in column B there
are several numbers.

A B
1 frank 10
2 billy 5
3 carol 6
on a seperate work sheet

A B C D
1 frank ? carol ?
2 billy ? frank ?
I need for excell to look at sheet 1 for carol and put the number into the
? box

can someone help me
 
Put this in D1:

=VLOOKUP(C1,Sheet1!$A$1:$B$4,2,1)

You can copy it down, as well as into B1

Hope this helps.

Pete
 
VLOOKUP is what you want. The formula may be slightly tricky at first to
learn, but there are other things to watch out for. If your spreadsheet
happens to have spaces after text in a cell vlookup will not work. So, keep
that in mind if you are wondering why everything you entered is perfect and
nothing is happening. Trim is a good function to know to help get rid of
spaces and such. =TRIM(A1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how would i wrtie this formula 2
Excel automaticly advancing copied cell numbers 5
Scrabble Value calculation for Welsh words 0
How to sum up the value in column based on a 5 day week period? 1
Lookup 2nd & last match with two conditions 6
Match and delete rows on two different sheets from reference numbers 4
Sorting columns into a table 6
Sorting a table on 2 columns 1

Back
Top