matching

  • Thread starter Thread starter vip7346
  • Start date Start date
V

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
 
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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a comprobation 1
Formula to match two conditions 2
VLOOKUP 4
Excel vba code to match duplicates 4
How to update data from multiple sheets to one specific sheets 4
Returning MULTIPLE values with Index and Match 1
Date and amount of last payment 3
Filtering of data in a master excel sheet from multiple sheets 3

Back
Top