Matching function

  • Thread starter Thread starter Manos
  • Start date Start date
M

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
 
Hi
any reason for not using VLOOKUP or INDEX/MATCH?
Some alternatives:
- use Data - Filter - Advanced Filter'
- use a worksheet_change event macro
 
Back
Top