VLOOKUP / ISNUMBER / SUMIF Stumped, can't get formula to run

I am stumped. I can do a VLOOKUP - been using excel since the Lotus 1-2-3 days. I am usually pretty resourceful with formulas, googled, picked another intermediate users brain and I can't get a formula to work.

I am matching the number in sheet 1, column A to sheet 2 column A and if they match I need to then populate information from sheet 2 column C into sheet 1 column B

Can anyone assist with a formula? I've tried is number, match, sumif...you name it! I can't get anything to run without errors. I feel like a dunce! I'm usually able to get through complicated formulas. Ugh!

In the future, please upload a sample workbook instead of pictures... it's a lot easier to work with. Thanks

Try this in B1 and copy down:

=IFERROR(INDEX(Sheet2!C:C,MATCH(A1,Sheet2!A:A,0)),"")

- Moo

I pasted it in and get False in column b - not the text from sheet 2 column C. Figured out the upload...hope that helps. Thank you...I am just having a brain freeze on this today.

It may be because you have a space in "Sheet 1" and "Sheet 2", instead of the standard Sheet1 or Sheet2. With the spaces, try this:

=IFERROR(INDEX('sheet 2'!C:C,MATCH(A1,'sheet 2'!A:A,0)),"")

If it still doesn't work, upload your sheet by:
1. Click 'Go Advanced' under the Quick Reply box.
2. Scroll down and click on 'Manage Attachments'
3. Click Add Files...
4. Select your file and click Open/OK
5. Click 'Upload File'
6. Click 'Done' (at bottom right of attachment screen)
7. Type your message in the reply text box
8. Click 'Submit Message'

- Moo

to begin with, in you're formula, you are refering to sheet 2, but the tab is named sheet2
2, you have the same formula repeated 6 times in that cell. delete all but 1

Now that I have the workbook to look at, the second formula I posted is what you need:

=IFERROR(INDEX('sheet 2'!C:C,MATCH(A1,'sheet 2'!A:A,0)),"")

However, as FDibbins noted, you have it entered in B1 multiple times. Delete the contents of the cell, then paste the formula into that cell one time and it will work.

Fill it down to the bottom of your list on sheet 1. When you see blank cells in column B after filling down, it is because there is no matching number on sheet 2.

- Moo

I see you got it working. Glad to hear it, and glad to help.

Be sure to mark the thread as [SOLVED] by clicking on 'Thread Tools' above your first post and selecting 'Mark Thread as Solved'
Also, a good way to say thanks to those who have helped is to click on the star to the lower-left of a contributor's post. It is appreciated.

- Moo