matching

[vip7346]

HI:
I need to match 2 sheets by the check amount .... can I use VLOOKUP:
sheet 1: check #, check amount
sheet 2: check amount, name, ....
Thank

 

[support]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin

 

[Frank Kabel]

Hi
if your amount is unique you could use VLOOKUP or
IDEX/MATCH. e.g. if you want to 'copy' the check# to sheet
two try the following formula on sheet2
=INDEX('sheet1'!$A$1:$A$100,MATCH(A1,'sheet1'!
$B$1:$B$100,0))