I am trying to return a value that corresponds to two cells being entered.
my data array is on a separate sheet.
PLease help!! thanks for reading!
See example below
I would like the C cells on Sheet 1 to autocalculate based on the formula matching any Sheet 1, A2 and B2 cell with sheet 2 data.
Can anyone help me figure out which formulas to use. I have not had luck with index/match working in this way.
Thanks again.
Last edited by chefbilly; 03-26-2016 at 08:46 PM. Reason: Unclear example
Paste this formula in C3 and copy down:Let me know if you have any questions.
Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you so much!
Ive been struggling with the syntax on this for a while.
You're Welcome and thank you for the feedback. If you haven't already please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.
Here's another one...
=VLOOKUP(A3,Sheet2!A$2:D$5,MATCH(B3,Sheet2!A$2:D$2,0),0)
Format as Percentage
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks