CODEWITHSUNDEEP
excel
aquatko
aquatko

Reputation: 37

Get value from range if cells match in Excel

Excuse me for the messy title, hope I would explain the problem below clearer.

This is an example what table I do have: https://i.sstatic.net/X9JSj.png

This is formula I use: =INDEX($G:$G, MATCH(B$1,$F:$F,0))

The task is: if types id and idnum match, and column name (A, B and C) matches value in type -> put value of the cell from value to the A, B or C column. I tried to search how to do this as well as trying out to do this with =IF and Index, Match, Match, but nothing worked out.

Any help is very appreciated!

Upvotes: 0

Views: 136

Answers (1)

Hariharan G R
Hariharan G R

Reputation: 549

Try this Formula in B2 cell

=IFERROR(INDEX($G$2:$G$15,MATCH(1,($E$2:$E$15=$A2)*($F$2:$F$15=B$1),0)),"")

After click F2 and Ctrl + Shift + Enter

enter image description here

Upvotes: 1

Related Questions