# Fairly simple question

#### Gokrish

##### New Member
I have 2 different spreadsheets with same 2670 rows of data.

Column A - serial #
ColumnB - Description
Column C - Y/N (Responses)

Column A - Serial #
Column B - Description
ColumnC - I need to enter "1" 1f the responses is 'Y" from spreadsheet 1, else i need to enter 0 if the response is "N"from spreadsheet 1.

Since the volume is huge I am looking for an easier way to do this. Can someone please help me with this. I am sure there is an easy way around with Vlookup or Hlookup, but need some guidance. This is kind of urgent.

Thanks
Avanthi

Last edited:

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Try in C2 of Sheet2:
=(index(Sheet1!\$C\$2:\$C\$100,match(A2&B2,Sheet1!\$A\$2:\$A\$100&Sheet1!\$B\$2:\$B\$100,0))="Y")+0

=IF(TRIM(UPPER(VLOOKUP(A2,[Book8]Sheet1!\$A:\$C,3,0))) = "Y",1,0)

Replace Book8 with the name of the workbook you wish to lookup the result from and Sheet1 with the name of the sheet.

The formula will return #N/A if the serial does not exist in your lookup sheet

did you mean two different spreadsheets (i.e. worksheets) or workbooks (file)?

Hello,

formula of cell C2 can be copied down:

Excel Workbook
ABC
1Serial #descriptionY/N
2No.1kind190
3No.2kind11
4No.3kind130
5No.4kind200
6No.5kind231
Sheet2

Replies
5
Views
102
Replies
2
Views
223
Replies
3
Views
152
Replies
1
Views
95
Replies
2
Views
520

1,207,423
Messages
6,078,441
Members
446,338
Latest member
AliB

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back