Please see attached file
trying to do a 2 way lookup, works for the first column, then when i drag it across it starts being funny.
Ive locked the cells where neccessary
Please see attached file
trying to do a 2 way lookup, works for the first column, then when i drag it across it starts being funny.
Ive locked the cells where neccessary
=INDEX($D$4:$O$7;VERGELIJKEN($C11;$C$4:$C$7;0);VERGELIJKEN(D10;$D$3:$O$3;0))
add the red text in your cells and drag to the right.
Then you get the right result.
I used the dutch formula. but just add the red text.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
=vlookup($c11,$c$4:$o$7,match(d10,$c$3:$o$3,0),0)
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks