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 things I've seen online only help with flagging the value, but not putting it into a cell so I can then use it in other equations.
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.
As variant
=TOCOL( XLOOKUP( firstRange, secondRange, secondRange), 3)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.
Hi Sergei, thanks for your help. Is there another method to do this as I'm currently on a version of excel that doesn't have the tocol function.
