LOOKUP based on two criteria

[jamiem4]

Hi,

I was wondering if someone would be able to help me.

I have a formula that searches a column in a table from the bottom up for a specific value and shows the corresponding value from a different column (and shows 'None' if no matching values are found):

=IF(ISNA(LOOKUP(2,1/(B:B=$F$3),A:A)),"None",LOOKUP(2,1/(B:B=$F$3),A:A))

What I need is for the formula to show the bottom-most value that also has another specific value in a different column. I've attached an example of what I mean. In the example, the formula needs to find the bottom-most 'Hello' in column B that is also 'Yes' in column C, and produce the value in column A - which would be '4'.

I hope this makes sense. Any help would be much appreciated.

Many thanks,
Jamie

[JohnTopley]

Jamie,
No attachment.

[jamiem4]

Apologies! Attached

[ChemistB]

Try

=IFERROR(LOOKUP(2,1/( $B$1:$B$10&$C$1:$C$10=F3&"Yes"), $A$1:$A$10), "None")
Does that work for you?

[jamiem4]

Amazing! Yes it does, thanks