VLOOKUP formula error

[phmalu]

Hi all,

Can you guys try to figure out what's wrong with my formula? Maybe VLOOKUP is not the best function in my case once the desired result will always be in column A but I really don't know what else to try.

=IF(H4=B3;VLOOKUP(I4;A4:D9;2;FALSE);IF(H4=C3;VLOOKUP(I4;A4:D9;3;FALSE);IF(H4=D3;VLOOKUP(I4;A4:D9;4;FALSE))))

Thanks to all!

 

[phmalu]

=INDEX($C$3:$C$9,MATCH(K3,INDEX($D$3:$G$9,0,IF(J3 < MIN($D$2:$G$2),1,(MATCH(J3,$D$2:$G$2,1)+(LOOKUP(J3,$D$2:$G$2) < J3)))),1))

Replace comma's with semi-colons for your system.


Note. Please try to post your samples in an Excel readable form as it's tiring to retype what your pictures show.

Thank you sir once again, it seems to be all good now!
Excel readable form? Like hosting my spreadsheet on Google sheets and posting the link here?
I'm sorry for not doing that earlier. Will keep that in mind if I need your help again.

 

[Aladin Akyurek]

Thank you sir once again, it seems to be all good now!

Great. Thanks for the update.

Excel readable form? Like hosting my spreadsheet on Google sheets and posting the link here?
I'm sorry for not doing that earlier. Will keep that in mind if I need your help again.

Yeah. See also: https://www.mrexcel.com/forum/about-board/508133-attachments.html