Vlookup with Match Reference

[mohammadsameja]

Please have a look at the workbook attached.

To explain:

1. Data is obtained by Pivot table from a large dataset
2. For some weeks a survey is not run on 'Zoom' and as default, Pivot would ignore that.
3. What I want to do is have a match on the Vlookup as to when something is not there, it doesn't use the column reference and shows me what is in the column that specific week (Might be Teams, not Zoom)

4. I tried using the formula and I cannot get it to work, please let me know how to fix it.

[Glenn Kennedy]

?? No expected answers, just a non-working formula, so...

=IFERROR(INDEX($B$3:$G$7,MATCH($I2,$A$3:$A$7,0),MATCH(J$1,$B$2:$G$2,0)),"")

maybe??

[wk9128]

J2 cell , formula , Drag down and accross

[mohammadsameja]

Thanks guys, got it solved!

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.