CODEWITHSUNDEEP
excelexcel-formula
al1en
al1en

Reputation: 511

Matching cell from two values

need help here :) I am not excel expert

I have a simple spread sheet with some data and I need to find the matching values from another sheet. Some help would be appreciated.

The data looks like this:

    d1    d2    d3    d4    d5
c1  1     5     4     4     3
c2  2     4     9     1     2
c3  4     4     7     8     4
c4  4     7     1     9     2
c5  4     4     7     6     8

So above c1, c2 etc. means Code's and d1, d2 etc. means Dates (future dates). The numbers between I need to catch in a different spread sheet

example

Code: c2 - User provides the code
Date: d4 - User provides the date

Value: 1 - this value I need to get with formula

Should I attach example file if needed?

If possible to use performance wise formulas as might be quite few of them. Perhaps INDEX/MATCH? if I know how to use it :) but I think also INDEX/MATCH will slow it down a lot, I might be wrong also :)

thank you for your help in advance.

EDIT: Added screenshot, might help also what is needed. Sample Data

Upvotes: 1

Views: 50

Answers (1)

SE1986
SE1986

Reputation: 2740

Assumptions / prerequisites:

  • Sheet1 cells (A1:F6) is your data / headers from your example
  • Sheet2 cell B3 is where the user types the code
  • Sheet2 cell B4 is where they type the date
  • Sheet2 cell B5 is where the value displays

this would be your formula in Sheet2 C5

=INDEX(Sheet1!A:F,MATCH(B3,Sheet1!$A:$A,0),MATCH(B4,Sheet1!1:1,0))

Upvotes: 2

Related Questions