Previous Topic Next Topic

Sorting and Matching Columns in Excel

Closed
jchapman1964 - Mar 11, 2010 at 06:22 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2010 at 10:42 AM
Hi People...

I see there are so many questions and answers on sorting data....... I have one for you, a solution for which would help me no end...

I have two excel spreadsheets.... one with a list of customers, and the qty of visits they took last year; the other shows a(regularly updated) list of customers, and their visits they are booking for the coming year.... so... like this

Sheet 1:
Customer QtyVisits Scheduled (Yes/No)

Sheet 2:
Customer QtyVisits

I have to put the data from Sheet 2 alongside the data from Sheet 1, i.e. copy it onto the same spreadsheet, and then be able to sort and match up both sets of data.... this way I can see who still needs to be scheduled etc etc...

Is there any way I can do this?

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 11, 2010 at 10:42 AM
Not sure exactly what you want

Lets say you want to see in last year status, how you are doing this year.

Assumption
Data on sheet1 starts at row 2
Column D in sheet 1 is available

In D2 write

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

Drag this formula to the last line
0