Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - Excel data is filled into the rows and columns of the specified template?
Excel data is filled into the rows and columns of the specified template?
After the data on the right is digitized, the following formula can be used on the left:

=IFERROR(INDEX($H:$H,MATCH($ A2 & amp; B$ 1,$ G:$ G & amp; $F:$F,)),"")

For the old version, press ctrl+shift+enter.