All about Microsofy Excel FUNCTION

D

danielawth

How to make it auto fill-in the value(column C2) to column between column F2 to column K2 whitch is matching column E2 with between F1 to K1 :-

C2 - 3000

E2 - JULY (WHITCH I KEY IN)

F1 - JULY
G1 - AUGUST
H1 - SEPTEMBER
I1 - OCTOBER
J1 - NOVEMBER
K1 - DECEMBER

If i key in JULY at column E2, so the value(C2) will auto fill-in to column F2 whitch is matching E2 & F1, by the same time, when i key in SEPTEMBER at column E2, the value of C2 will auto fill-in to column H2.
thanks for help
Daniel Law
 

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

Conditional Formatting or ??? 4
looking a value in an array text values 2
sumifs function 3
Help to to create a Formula or Macro 3
remove duplicate rows from specific data in a column; excel 2007 1
sum alphanumeric cells 5
UDF for multiple heading indexing 4
Fetching data and deleting original data 3

Top