Match Cells across 2 Work sheets then copy/paste a cell

[tripey]

Hey guys, I've been searching for a couple hours now trying to figure this out. Run down:

Got two Worksheets. Worksheet2 has extra information I'd like to copy over to Worksheet1. I'd like to match a number in column A of both worksheets. If there's a match, then I'd like to copy a cell in that row of Worksheet2 and paste it into a cell in WorkSheet1. Not sure why I haven't been able to find an answer. At first, I was strictly looking at macros, but then found other posts about Vlookups... but for some reason I just can't get it to work. Attached is a sample workbook as the original one has over 60,000 items.

Thanks in advance

[tripey]

Oops, I forgot to mention that the UOM in Worksheet2 is what I want to copy to Column E in Worksheet1. Sorry

[acerrhod]

try this:
=VLOOKUP(A2,Sheet2!$A$2:$B$9,2,FALSE

it will give 0 values if the result column was blank but try to input some data on the price and see what happen

[acerrhod]

try this:
=VLOOKUP(A2,Sheet2!$A$2:$B$9,2,FALSE

it will give 0 values if the result column was blank but try to input some data on the price and see what happen

[acerrhod]

try this
=VLOOKUP(A2,Sheet2!$A$1:$H$9,8,FALSE)

[benishiryo]

hi tripey, welcome to the forum, you can try this in Sheet1!E2:
=VLOOKUP(A2,Sheet2!$A$2:$H$9,MATCH(E$1,Sheet2!$A$1:$H$1,0),0)

or just this if UOM is the only item you need:
=VLOOKUP(A2,Sheet2!$A$2:$H$9,8,0)

if you have instances where SKU cannot be found, cover it with IFERROR:
=IFERROR(VLOOKUP(A2,Sheet2!$A$2:$H$9,8,0),"")

[tripey]

Thanks guys, I'm checking this out right now. So far the formula, =VLOOKUP(A2,Sheet2!$A$2:$H$9,8,FALSE) works for the small sample file I uploaded, but I'm still getting #N/A on the larger file that I need it to work on. Might attach a condensed version of the file for you guys to look at.

[acerrhod]

it gives you an #N/A because cannot find the lookup value from the range, but you can alter the #N/A by displaying space when the lookup not find anything, you may modify the formula:
1. =IFERROR(VLOOKUP(A2,Sheet2!$A$2:$H$9,8,0),"")
2. = if(iserror((VLOOKUP(A2,Sheet2!$A$2:$H$9,8,0)),"",(VLOOKUP(A2,Sheet2!$A$2:$H$9,8,0))
both will work

[tripey]

Yep, not sure why it's working in the sample file I initially uploaded but not in the actual file I'm working on. Here's a condensed version of it.

[tripey]

I know, but for some reason it doesn't work with the actual file that I need it to work on. I just uploaded a smaller version of it . In it, there are two skus that will match in both worksheets, but it still can't find the lookup value. I've been at this for a couple hours now, wondering if it's something with the file settings.

Thanks man

it gives you an #N/A because cannot find the lookup value from the range, but you can alter the #N/A by displaying space when the lookup not find anything, you may modify the formula:
1. =IFERROR(VLOOKUP(A2,Sheet2!$A$2:$H$9,8,0),"")
2. = if(iserror((VLOOKUP(A2,Sheet2!$A$2:$H$9,8,0)),"",(VLOOKUP(A2,Sheet2!$A$2:$H$9,8,0))
both will work

[acerrhod]

The date from column A Sheet1 was a text value and the data in column A in sheet was a number value, that is why it giving #n/a but you may modified the formula by:
=VLOOKUP(VALUE(A22),Sheet2!$A$2:$H$23,8,0)

try if it working
and to alter the #n/a if no found data

=IFERROR(VLOOKUP(VALUE(A22),Sheet2!$A$2:$H$23,8,0),"")

[tripey]

Oh!!! the data type was different that's why it's not matching! I see, I'll get back at it right now.

Thanks

The date from column A Sheet1 was a text value and the data in column A in sheet was a number value, that is why it giving #n/a but you may modified the formula by:
=VLOOKUP(VALUE(A22),Sheet2!$A$2:$H$23,8,0)

try if it working
and to alter the #n/a if no found data

=IFERROR(VLOOKUP(VALUE(A22),Sheet2!$A$2:$H$23,8,0),"")

[tripey]

Awesome, it works. This is my 2nd time messing with excel. Got a lot to learn, thanks man.

The date from column A Sheet1 was a text value and the data in column A in sheet was a number value, that is why it giving #n/a but you may modified the formula by:
=VLOOKUP(VALUE(A22),Sheet2!$A$2:$H$23,8,0)

try if it working
and to alter the #n/a if no found data

=IFERROR(VLOOKUP(VALUE(A22),Sheet2!$A$2:$H$23,8,0),"")