(SOLVED)I want to search sheet 1 columns A thru F for a match to J2 if found return value in column G of same row as match ex. when the search is performed for M28 on sheet 2 it should find the match in B47 on sheet 1 and then show 46 from L47 on sheet 1 in M28 on sheet 2, I hope this helps clears up what I'm looking for.
Bookmarks