Matching function

[Manos]

sheet 1 i have accounts that have been retrieved from a
database. those figures are coming in months.

in another sheet eg. sheet 2 i have create a table that i
want to bring some specific figures from the sheet 1
based on the month i have already select from the sheet2.

IE. if in the sheet 2 i have place in A1 the 4 (April) i
want to have in the table the figures from column 4 from
sheet1.
In sheet 2 i have a name paul. so when the paul matches
with paul in sheet 1 then i want to bring the sales of
paul from sheet 1 to sheet 2.

IS it possible?

The problem is that i do not want to use the Vlookup
function.

With regards Manos

 

[Frank Kabel]

Hi
any reason for not using VLOOKUP or INDEX/MATCH?
Some alternatives:
- use Data - Filter - Advanced Filter'
- use a worksheet_change event macro

 

[Manos]

i do not want to use vlookup

there is no problem with match or index
or even with a macro