If data exists in row.. if not leave empty

**samfarrugia** · 09-27-2012, 12:38 PM

Hi.. i have three sheets...

1st sheet has a certain amount of data, Data code and value
2nd sheet has the same information but more data, Data code and Value

3rd we need to comapre the values from sheet 1 and sheet 2 -

I want the DATA CODE to be retrieved autmoatically, and when there is not data, the cell is left empty.... (see sheet 4 - I do not want to do it like this; Sheet three is how the results have to be)

thanks
Sam

**JieJenn** · 09-27-2012, 12:48 PM

=IF(ISERROR(VLOOKUP(A2,Sheet1!A:B,2,FALSE)),"",VLOOKUP(A2,Sheet1!A:B,2,FALSE))

**Pepe Le Mokko** · 09-27-2012, 12:50 PM

As you posted an xlsx file you probably use a post 2003 version so, try also

Please Login or Register  to view this content.

**jake.masters** · 09-27-2012, 12:51 PM

Try:

=IF(ISERROR(VLOOKUP(A2,Sheet1!A:B,2,FALSE)), "", VLOOKUP(A2,Sheet1!A:B,2,FALSE)) in B1

**Pepe Le Mokko** · 09-27-2012, 12:53 PM

@jake.masters

Why do I get the feeling your answer looks very much like post #2?

**jake.masters** · 09-27-2012, 01:35 PM

I clearly submitted it without refreshing my page because I was looking at his spreadsheet. Would you like me to delete it?

**samfarrugia** · 09-28-2012, 03:58 AM

Originally Posted by samfarrugia

I want the DATA CODE to be retrieved autmoatically, and when there is not data, the cell is left empty.... (see sheet 4 - I do not want to do it like this; Sheet three is how the results have to be)
Sam

Hi.... i do not want to retrieve the value.. but the coloumn DATA CODE from sheet 2!

**jake.masters** · 09-28-2012, 09:31 AM

You are saying you just want what is in sheet 2 column A to be in sheet 3 column a? Put this in A2 on sheet 3 and drag down.

=IF(ISERROR(VLOOKUP(A2,Sheet1!A:B,1,FALSE)), "", VLOOKUP(A2,Sheet1!A:B,1,FALSE))

That will return the data code...but you already have that. I am not sure I understand what you are looking for.