Forum Discussion
Solved
Trying to pull a matching value to then use in another equation
Hi all, I am attempting to pull a matching value from the two columns seen below (this value then needs to be used in another equation), but cannot seem to figure out how to do it. All the thing...
On legacy Excel for such sample
enter in E3 formula
=IFERROR( AGGREGATE(15,6, (ROW($B$3:$B$10) - ROW($B$2))/ISNUMBER( MATCH( $B$3:$B$10, $C$3:$C$6, 0)), ROW() - ROW($E$2) ), "" )and drag it down till empty cells appear. Be sure first list is longer than second one.
Hi Sergei, thanks for your response. Is there another method for achieving this as the version of excel I'm using doesn't support the "tocol" function?
On legacy Excel for such sample
enter in E3 formula
=IFERROR( AGGREGATE(15,6, (ROW($B$3:$B$10) - ROW($B$2))/ISNUMBER( MATCH( $B$3:$B$10, $C$3:$C$6, 0)), ROW() - ROW($E$2) ), "" )and drag it down till empty cells appear. Be sure first list is longer than second one.
It works! Thank you very much for your help
You are welcome