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.
As variant
=TOCOL( XLOOKUP( firstRange, secondRange, secondRange), 3)
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.