Looking for information on creating a formula in excel

G

Guest

Looking to create a formula for the following. Sheet 1 column a have a list
of names a1-a15. On sheet 2 have a list on names a1-a15 with list of numbers
in c1-c15. If names from sheet 2 same as anyone on sheet one than the
corresponding number will be posted. ie: on sheet one name george appears.
on sheet two the name george in a1 and bill in a2 are listed. want to search
that is george is found than the corresponding number will be posted on sheet
3. Hope someone can make sense of this
 
T

Tom Ogilvy

Look in Excel help at the Vlookup worksheet function.

Entries of this function would be on Sheet 3
 

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

Search an array of sheets for an array of numbers & return count of numbers 11
Is there an easier way 4
Extracting data from consecutive rows into every "nth" row 1
Index, Match Help 2
using defined name in UDF 7
Run two macros for two different sheets 11
Copy adjacent Sheet and name from a list 42
countif function 1

Top