I would like to compare 2 columns.Solved/Closed

Question

Hello, 

I would like to compare 2 columns A to F, if the value is the same I would like to populate the value of column C with the value from Column G. Does anyone know the best way to to this.

Here is the data:
A      B              C              D                   E         F      G
BID	Pictures	Errors	Percentage		BID	Errors
0	3	        #N/A			                10	5
1	203	        #N/A			                12	42
2	5676	#N/A			                14	5
3	1302	#N/A			                15	278
5	2	        #N/A			                19	124
8	651	        #N/A			                21	62
9	6191	#N/A			                35	97
10	7063	#REF!			                44	25
11	323	        #N/A			                606	2
12	56800	#REF!			                830	12
14	2608	#REF!			                1287	1
15	654022	#REF!			                2532	1
16	5125	#N/A			                2838	1
19	89541	#REF!			                2877	33

So what I would like to see if Column A = Column F then I would like to put the value in from Column G

Thanks,

David

dsrice · Answer

So it did not keep the formatting, if you have any questions let me know.

Zohaib R · Answer

Hi David, 

Use this formula in column C: 

=IF(A1=F1,G1,"") 

Use the Microsoft Excel's fill handle to fill the formula for the rest of the cells in the column. 

Do reply with results.  
  
Thanks & Regards 
Zohaib R 
#iworkfordell

Zohaib R · Answer

Hi David,

Data you have posted is little confusing. A little clarification will be helpful here. I copied the data and treated the spaces as tabs and put it in an excel sheet. It appears as:

Column A:	BID
Column B:	Pictures
Column C:	Errors
Column D:	Percentage
Column E:	 BID
Column F:	Errors
Column G:	?

There is no header for "Column G", "Column C: Errors" is all "#N/A" or "#REF!" as if there is some formula in Column C. It is a little difficult to work with this data. Kindly update the sample-file to the below mentioned location:

https://authentification.site

I will try to update the formulas in the sample sheet and will upload to a similar location which you could download later.

Please do write back to us.

Zohaib R · Answer

Hi David,

Please put this formula in column C of your sheet and use excel's fill handle and drag till the last value of the column, check if it returns what you want:

=IF(ISNA(VLOOKUP(A2,$F$2:$F$1048575,1,FALSE)),"",F2)

Do reply with results.

Zohaib R · Answer

Hi David,

Sorry for uploading the file late, I had some technical issues:

http://speedy.sh/N3XKr/Picture-errors.xlsx

Hope this helps.

David · Answer

Thank you for your help, it has been awesome!

David

David · Answer

Wait it does not look like it is populating the correct values into column C. For Example it should be 5 for errors for Bid 10.

Thanks,

David

David · Answer

Wouldn't the last part of the formula need to reference Column G?

Zohaib R · Answer

Hi David, 

I have tried changing the formula to suite your need, please download the below mentioned file and check if this helps. 

http://speedy.sh/2aVjY/Picture-errors.xlsx 

Do reply with results.  
  
Thanks & Regards 
Zohaib R 
#iworkfordell

Zohaib R · Answer

Hi David,

I am glad to know this finally worked for you. Please feel free to get back to us if you have any further queries.

I would like to compare 2 columns.

10 responses

Subscribe To Our Newsletter!