vlookup with if or where clause
Posted on 2014-08-19
I have a vlookup that I am trying to make it a little more functional:
This pulls back some of the data that i need.
However, i want it to be more exact. I need it to only pull back the data if the data in another column in sheet IP contains the word 'last'
so basically i need something like this:
The table example is below. Of course, with my simple code about I just pull back a 1 every time ColumnA has a 2. However, I only want to pull back the match where the first match happens.
COLUMNa COLUMNb COLUMNc
2 1,2,3,4 Last <-------i just want this one to populate when there is a 2 in my vlookup formula
3 a,b,c Last <-------i just want this one to populate when there is a 3 in my vlookup formula