How to use vlookup function in excel to fetch data from two column
i want to use vlookup function in excel to fetch cheque no where amount match. i have two table
Table one (say table A)consist amonut only. Table two (say table B) consist amount with cheque number.
Now problem is that i use vlookup but there are 5 time 10000 amount in table A and 6 times 10000 amount in table B
but when i fetch cheque no it give same cheque number against all the 5 times 10000 amount. please solove the prolem