How do I create formula in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Would like information to create a formula for the following senario.

In sheet 1 column A have a list of names.

In sheet 2 column A have a list of names and column c a list of numbers.

want to search sheet 1 column a with names from sheet 2 column a and if
found post the corresponding number from sheet 2 column c.

Any help appreciated
 
Tell me if this is what you are looking for:

=IF(ISERROR(VLOOKUP(Sheet2!A1,Sheet1!A:A,1,)),"",C1)
 
You must log in or register to reply here.

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

Code works but goes into endless loop and crashes 1
Copy columns and paste with blank column between 5
Search an array of sheets for an array of numbers & return count of numbers 11
Excel formula for counting nr records with data and related empty fields 3
Find a value in a sheet and replace it with another value if it matches 8
Excel module: Mark records if it contains names out of another list 4
Array code only works on selected sheet 14
When found add it to the last and display total in Msgbox 23

Back
Top