Matching cells [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

I would like to know if there is any formula for this situation.

I have Column A: account numbers. Column B: Account Balance Column C: Debits per week. This information is sorted by date. In a different spread sheet (column A)I have a list of accounts sorted in alphabetical order. I would like to match Column A, B and C in Spreadsheet #1 to the list of accounts I have in Column A spreadsheet # 2.

Any help on this matter would be great.

Thank you

2 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi

In column B of Sheet 2, put the formula =vlookup(A1,Sheet1- entire range,2, false)
In column C of Sheet 2, put the formula =vlookup(A1,Sheet1- entire range,3, false)


Do let me know If it helps...
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
Vlooku is good option but make sure account numbers are not repeating in column A bcoz vlookup will fail to pick 2nd occurrence of the repeated account number ....

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!