Comparing and Returning

I have two sheets. On Sheet1 are two columns of numbers. On Sheet2 is a column that matches one of the columns on Sheet1. Here is what I am trying to do:

If Sheet1:A1 = Sheet2:B1
then enter Sheet1:B1 into Sheet2:C1

I know that this is going to take the VLOOKUP function, but I have yet to get it to work.

Any help would be greatly appreciated!

Scott

If you are matching on a row by row basis as you have shown, then you don't need Vlookup. You need: =IF('Sheet1!A1=B1,'Sheet1'!B1,"") copied down.

But if you want to see if any number in column A of Sheet1 matches B1 of Sheet2, then try:

=IF(ISNUMBER(MATCH(B1,'Sheet1'!A:A,0)),VLOOKUP(B1,'Sheet1'!A:B,2,FALSE),"")

or

=SUMIF('Sheet1'!A:A,B1,'Sheet1'!B:B) if the matches are unique or you want to sum multiple matches...

So does this work, then?:

=IF('Sheet1!A1=B1,'Sheet1'!B1,"")

I am still a bit confused as the restrictions.

Are you checking say all of Column A in Sheet1 and comparing to one cell in FoldInv, column W and then copying down to compare column A to the next cell in column W?

or is it strictly a one cell to one cell matchup?

Try

=IF(Sheet1!A2=FoldInv!W2,Sheet1!B2,"")

God, I think Im confusing myself here. Im so sorry. Let me try again.

There is a column of numbers in FoldInv:ColumnW. They look like this in the column:

12345
12345
12345
12345
12346
12346
12346
12346
12347
12347
12347
12347 and so on...

In the other sheet (Sheet!1) there are two columns B and C. Those numbers look like this:

ColumnB ColumnC
12345 66436
12346 66437
12347 66438
12348 66439 and so on...

What Im wanting to do is look at FoldInv:ColumnW. Whenever that number matches the number in Sheet1:ColumnB to enter the contents of Sheet1:ColumnC into the cell that the formula is entered into.

I hope that makes more sense. Im not good at wording this stuff very well. Please accept my apologies. And thank you very much for your help!

You have duplicates in the sample... does sheet1 have duplicates too? Do we need to have different numbers returned beside each duplicate value in column W from Sheet1?

It would be better if you post a sample workbook showing expected results.... This should eliminate the mutual confusion we are having.

Since Sheet1 seems to only show unique entries in column B, try:

=VLOOKUP(B1,Sheet1!$B$1:$C$21,2,FALSE)

copied down.

Looks like you keep switching the lookup sheet and the database sheet...

Try:

=INDEX(Sheet1!B:B,MATCH(W2,Sheet1!C:C,0))

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save