What function do i use?
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 |
What function do i use?
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 On Jan 14, 7:04*pm, motorman2008 wrote: 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 |
What function do i use?
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) "motorman2008" wrote: 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 |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com