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,
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.
Hope this helps.Please Login or Register to view this content.
Snook
Hi - It works, but when I move the table into different sheets/worksheets, it won't work.
Without an attachment it is hard, the references need to refer to the sheetname as well as the range
=LOOKUP(1,1/($D$3:$D$9=A3),$E$3:$E$9) is a non array based answer, but may need to be
=LOOKUP(1,1/('Yourothersheetname'!$D$3:$D$9=A3),'Yourothersheetname'!$E$3:$E$9)
if the active row is always the last row otherwise
=LOOKUP(1,1/($D$3:$D$9=A3)*($F$3:$F$9="active"),$E$3:$E$9)
and similar adjustments may need to be made for the other sheet
Last edited by davsth; 02-28-2020 at 08:18 AM.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks