Think I am almost there, but not quite.
have input =VLOOKUP(A3,Sheet1!A2:A384,1,FALSE)
I put both spreadheets into same work, one tab called mater list another called sheet 1
but what is getting returned in that box is the ID number above.
Is the A3 in that formula refering to A3 on sheet 1, or A3 on the sheet i have the formula.
dont think Ive got my head around how Vlookup works
I think it is, look up the value of A3 on this spreadsheet, on another spreadsheet called sheet 1, in the range A2 to A384??, not sure what the 1 does?, i understand the false bit.
I want the function in column J of “master spraedsheet” to look at the value in column A of master spreadsheet, look this up in sheet 1 and return the value that is in column 4 of the corresponding row.