If/Array formula assistance please!

[BBogert]

Hi all,

I have a set of 16 columns with titles that change. I am trying t
link cells to pull values from another worksheet based on comparabl
title names, but nothing is working. Assuming the title is in B6, an
the list of titles on the worksheet are in columns B4:CQ4, and I wan
to pull the information from row 35 for whatever column matches th
title, this is what my formula looks like:

=IF($B$6=Sheet2!$B$4:$CQ$4,Sheet2!$B$35:$CQ$35,0)

This is being entered as an array, but nothing seems to help. Than
you

 

[Patti]

Will "Lookup" work?

=Lookup(B6,Sheet2!$B$4:$CQ$4,Sheet2!$B$35:$CQ$35)

 

[BBogert]

THANK YOU!!!!! This has been aggravating me for hours, never thought t
use a different function... THANK YOU!!!!

 

[Frank Kabel]

Hi
I would suggest to use:
=HLookup(B6,Sheet2!$B$4:$CQ$35,32,0)

to ensure you find the exact match