Previous Topic Next Topic

Matching cells

Closed
vefm - May 19, 2009 at 08:35 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 21, 2009 at 02:45 AM
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 responses

Answer 1 / 2
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
May 19, 2009 at 11:32 PM
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...
0
Answer 2 / 2
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
May 21, 2009 at 02:45 AM
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 ....
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses