If year = X and Value = A,B,C then show N...

N

Neall

Good morning, I have a table of data A8:M23 which has a column A8:A23 that
has a date and I have a column B8:B23 that has part numbers

I have 3 sets of columns with Part numbers A,B,C 27 - 31 that have
corresponding part numbers the headers of each column of part numbers are OLD
CPU, OLD VU and RVU

What I want to do is create a match statement that says if year = 2007 and
part numbers for that year are W,X,Y then show column header for whichever
category those part numbers fit in.

Its impossible for there to be a mismatch of part numbers per year they
either fit into A,B,C.

Any suggestions.

Thanks
 

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

Macros to convert Data into date format and then plot in graph 7
I would like to concatenate it, or use a macro, to a line of text 4
Help with this formula 13
if then insert and add 1
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 2
Macro that analyses data from 3 columns and puts result in 4th 2
help with HUGE file building list 6
Finding a Value Between Two Numbers and Returning Corresponding Value 12

Top