I am trying to pull Item pricing from Sheet 2 over to Sheet 1. However, It does not recongize/pull pricing for every item. For the items on Sheet 1 that Vlookup can't find from Sheet 2 it returns an #N/A which is Fine I can fix that. BUT, If I go to Sheet 2 and Ctrl-F (control Find) enter that item number It does find the item.
Sheet 1 only has a Mfg. # and Sheet 2 has both Mfg.# and Pricing
Q) So why isn't Vlookup finding that item number on Sheet 2 and return the Price for me on Sheet 1.
Funtion I am using is
=IF(ISNA(VLOOKUP(K3,Sheet3!$A$2:$B$5551,2,0)),"0",VLOOKUP(K3,Sheet3!$A$2:$B$5551,2,0))
Sheet 1 only has a Mfg. # and Sheet 2 has both Mfg.# and Pricing
Q) So why isn't Vlookup finding that item number on Sheet 2 and return the Price for me on Sheet 1.
Funtion I am using is
=IF(ISNA(VLOOKUP(K3,Sheet3!$A$2:$B$5551,2,0)),"0",VLOOKUP(K3,Sheet3!$A$2:$B$5551,2,0))