This is my formula which works but would like to modify it so when the lookup value is found it also brings in data to sheet 1 from (sheet 2) columns F & G on the same row.
Currently when sheet 1 B1 matches sheet 2 column E on it populates that data from Sheet 2 onto Sheet 1 column E. What would be great if when the lookup values is match it also pull data from sheet 2 columns F & G.
HTML Code:
Bookmarks