Re: Newbie Question - vlookup, I think



in C1 for your First column try this:
=IF(AND(A1="Remote",B1>5,B1<10),"X","")

then modify for other cells accordingly

Thanks

.


Loading