Vlookup/hlookup/match/index?

**margggggg** · 11-28-2012, 06:44 PM

Hello Excel Forum!

I need a formula that when I paste it into Column D, it will look up what is in Column A in the same row and if the value in B is "New" AND the value in Column A in the next row is the same as in the previous row AND the value in Column B in the second row is "TA Screen", then put the value in Column C of the first row into Column D of the first row.

The data will always been in this order, if that helps.

Also, I may be going about this completely wrong. Open to suggestions. Thanks in advance!!!

**FDibbins** · 11-28-2012, 06:59 PM

you're explanation was a bit confusing lol, but see if this is what you want? copy this to where-ever you need it, and copy down...

=IF(AND(B2="New",A2=A3,B3="TA Screen"),C2,"Not Found")

**margggggg** · 11-28-2012, 07:10 PM

Haha. I have been working on this for so long and got to =IF(AND(A1=A2,B1="New",B2="TA Screen"),vlookup( and I thought my brain was going to explode.

So simple. Thanks.

**margggggg** · 11-28-2012, 07:10 PM

duplicate post

**FDibbins** · 11-28-2012, 07:46 PM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)