i have a list of names in a range B4 to B37. Now in cell J4 i want to insert the value from a cell in column G. Now to identify that cell in column G, I want to pick the content of B4, then search in range B71 to B93 and if found return the value from the corresponding cell in column G. for example:.
if B4=Apple, then search for “Apple” in B71:B93 and if found in say B80 then return the value of G80 to J4.
If this is set for J4 it can be extrapolated to full range of J4:J37
Is this possible?