If data exists in coloumn... show data... . if not leave empty

**samfarrugia** · 09-28-2012, 05:47 AM

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 - BUT...BUT...BUT..

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)

IE: I am not looking to retrieve the value.. that is fairly easy with the vlookup... I am looking to retrieve the 'DATA CODE' in Sheet 3 automatically from SHEET 2...

thanks
Sam

**swapnilj1** · 09-28-2012, 06:23 AM

Hi Sam,
Please find attach file which is working as per your above request.
Just click on Get data button

Thanks
Swapnilj1

**Sindhus** · 09-28-2012, 06:24 AM

you can use if(Sheet2!A2="","",Sheet2!A2) or you can change display settings for your sheet in the excel options. There is one option, which says "Show zero in cells that has zero value". I don't know where it is located in excel 2003.

**samfarrugia** · 09-28-2012, 06:39 AM

Perfect. Thanks Sindhus. One other question... I am doing a vlookup in the next coloumns... is there a way that if there is no value nothing comes up too?? IE Cell is left blank

Swapnil, thanks aswell, but prefer to use formulas rather than scripts!

**Sindhus** · 09-28-2012, 06:48 AM

You can use "iferror" formula. If it is not available in 2003, you can put a dummy data in sheet2 at the end of your table. 0 in column 1 and (Space) in column 2

**samfarrugia** · 09-28-2012, 06:56 AM

The data that its returning is 'TRUE'

I used...

=IFERROR(VLOOKUP(A2,Sheet1!A:O,15,FALSE)="",VLOOKUP(A2,Sheet1!A:O,15,FALSE))

I need it to return the value or leave blank!!!