VLookup/Match ????

[JOANNMU]

I am trying to lookup data in Excel 2010 on two spreadsheets. Sheet 1, column N is my material number, Column V is my delivery time. I have like data in sheet 2 with delivery time on column E. I need to populate column W in sheet 1 with the data in column E on sheet 2. I tried match, lookup, etc. and nothing seems to work.....******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID" style="width: 0px; height: 0px; display: block;"></object>

 

[jarjarbingie]

sample pls?

 

[JOANNMU]

I am not seeing how to attached an excel spreadsheet to the forum.....ugh!******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID"></object>

******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID" style="width: 0px; height: 0px; display: block;"></object>

 

[jarjarbingie]

http://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[JOANNMU]

The example is in the following link.....

https://www.dropbox.com/s/6r2tdtinxsrzsfo/Example.xlsx







******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID" style="width: 0px; height: 0px; display: block;"></object>

 

[jarjarbingie]

in cell W2 in Sheet1 put:

=IFERROR(OFFSET(Sheet2!$R$1,MATCH($N2,Sheet2!$E$2:$E$100,0),0),"")

 

[JOANNMU]

I tried the formula but the cell still is not pulling in any data....still blank...

in cell W2 in Sheet1 put:

=IFERROR(OFFSET(Sheet2!$R$1,MATCH($N2,Sheet2!$E$2:$E$100,0),0),"")

******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID" style="width: 0px; height: 0px; display: block;"></object>

 

[jarjarbingie]

it worked for me, at least for the first row (Item Number 34543), it returned 14, for the rest of your example they will be blanks because they don't have an exact match in Sheet2..

 

[JOANNMU]

Does the data need to be sorted? I cannot sort my data at all....******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID"></object>

it worked for me, at least for the first row (Item Number 34543), it returned 14, for the rest of your example they will be blanks because they don't have an exact match i******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID"></object>
******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID" style="width: 0px; height: 0px; display: block;"></object>

 

[jarjarbingie]

no.. I worked on the actual data you sent.. I'm not sure if it is because you're using a Mac..