Comparing two formulas

Closed
sea - Jun 29, 2011 at 10:46 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Jun 30, 2011 at 01:52 AM
Hello,
c d e f g h I J K
chk nr debits credits chk nr date amount
99487 0 69.00 98964 2/24/2011 810
99488 0 250.47 99066 2/24/2011 3050
99489 0 142.44 99080 2/9/2011 16.41
99490 0 187.97 99196 2/9/2011 10.21

I have this table and I need to compare the data in column C (check number) with corresponding check numbers in the column F (ranked differently) and bring up the results from F to I, G to J, and H to K.

Thanks,
Sea

1 response

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jun 30, 2011 at 01:52 AM
Use Vlookup as :
in column I:
=Vlookup(c2,F:F,1,false)

in column J:
=Vlookup(c2,F:G,2,false)

in column K:
=Vlookup(c2,F:H,3,false)

Regards,
Rahul
0