Vlookup Return "Active" Value

Hi,

I have attached the spreadsheet of the example. I am trying to lookup value (A100, A200, etc.) and return the "Active" "Price".

Thanks in advance for your help.

Hi spider_min,

There's no doubt a more efficient solution but this array formula will work for you. Input into cell B3 and confirm entry using ctrl + shift + enter (rather than just enter). The formula should have curly brackets round it if done correctly.

Please Login or Register  to view this content.

Hope this helps.

Snook

Hi - It works, but when I move the table into different sheets/worksheets, it won't work.

This one this workout perfectly. Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

=LOOKUP(1,1/($D$3:$D$9=A3)*($F$3:$F$9="active"),$E$3:$E$9)

Thank you for all your help.