Vlookup with either/or
You're Welcome!
"TH" wrote:
On Sep 17, 11:16 am, Teethless mama
wrote:
=IF(COUNTIF(data1,A18),VLOOKUP(A18,data1,4,),VLOOK UP(B18,data1,4,))
" wrote:
Hi,
I'm hoping someone can help me out with what should be an easy task,
but I can't quite get it.
I'm trying to do a Vlookup for 2 columns (either/or) using this
formula:
=VLOOKUP(OR(A18,B18),data1,4,FALSE)
where 'data1' is my array on a separate sheet. It works fine for a
single vlookup, but no luck using the 'or' function.
Does anyone know how to do this?
Thanks in advance for any replies.
Terry
Thanks Teethless Mama! That worked exactly like I needed!
|