Comparing two formulas

Closed
sea - 29 Jun 2011 à 10:46
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 30 Jun 2011 à 01:52
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 7 February 2011 Status Contributor Last seen 30 September 2013 120
30 Jun 2011 à 01:52
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