Solved: vlookup with condition

[danovkos]

hi all,
pls. how can i do following with formula?

I try ty use vlookup to return value from column C, but i need to add one condition (return required value only if is in the same row in column WW value „yes“).

How can i do this please?
thank you for your help

[mikerickson]

Can you attach a sample workbook with the desired result?

[danovkos]

Here it is:

[mikerickson]

Put this CSE formula in G3 and drag down.
=MID(VLOOKUP("Yes"&F3, $B$3:$B$24&$A$3:$C$24, 3, FALSE), 4, 100)+0

This needs to be entered with Ctrl-Shift-Enter (Cmd+Return for Mac)

[danovkos]

yes, this is it
thank you very much for your help