PDA

View Full Version : Solved: vlookup with condition



danovkos
11-27-2009, 12:39 AM
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
11-27-2009, 01:41 AM
Can you attach a sample workbook with the desired result?

danovkos
11-27-2009, 02:35 AM
Here it is:

mikerickson
11-27-2009, 02:48 AM
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
11-27-2009, 04:34 AM
yes, this is it :)
thank you very much for your help:clap: :rotlaugh: