Hi, I have another problem. I have a table of cells that are dependant on the information entered into cells, i.e. there is a key to the numbers required, I've explained all in the attachement hopefully.
Many thanks
Hi, I have another problem. I have a table of cells that are dependant on the information entered into cells, i.e. there is a key to the numbers required, I've explained all in the attachement hopefully.
Many thanks
Enter the following formula in D3 and drag down. Let me know if it helps
Please Login or Register to view this content.
hi Mearsy, is this what you need:
=INDEX($H$3:$J$5,MATCH(C3,$G$3:$G$5,0),MATCH(B3,$H$6:$J$6,0))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Works an absolute treat, many thanks Guys.
---------- Post added at 09:09 AM ---------- Previous post was at 09:07 AM ----------
Works a treat,thanks Guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks