Vlookup

Closed

andrus - Jan 24, 2010 at 04:34 AM
andrus - Jan 24, 2010 at 04:44 AM

Hello,

I have dificulties to use vlookup function.
I have 2 sheets . Sheet2 is full database together with EAN codes. Sheet1 is anaother database without EAN codes. I would like to find from Sheet2 corresponding EAN codes and print these into Sheet1 column C.

I used VLOOKUP function but without success. Always getting reply #N/A. What I did wrong? If anyone would like to help me I can send him my excel file. (my mail is: info(at)egtt.ee)

Thank you in advance,
Andrus

Vlookup
Iserror function in excel with vlookup - Guide
Transfer data from one excel worksheet to another automatically vlookup - Guide
Vlookup compare two columns and return a third ✓ - Excel Forum
Match value in 2 separate columns and return a value from a 3rd - Excel Forum
Vlookup from multiple columns with only one return - Excel Forum

1 response

Answer 1 / 1

andrus
Jan 24, 2010 at 04:44 AM

you can download this file:

http://www.egtt.ee/files/menu//2010012412423838.xlsx

Similar discussions

How to invoke VLookUp function in Excel VBA.

Removing "FALSE" from an IF statement with a VLOOKUP

Comparing columns and returning value

Excel 2007 Using vlookup function in VBA

Copying Excel data from one sheet to another based upon contents of a cell

Similar discussions

Subscribe To Our Newsletter!