View Single Post
  #1   Report Post  
lucky
 
Posts: n/a
Default need funct to match data in 3 seperate spreadsheets column 1 to v.

I need to write a function in Excel to find matching data in 3 seperate
spreadsheets, column 1 so that I can view and compare the corresponding data
in column 5 of those 3 spreadsheets. I am hav9ing problems writing the
function: first phase
=VLOOKUP(Sheet1!A3:A1588,Sheet2!A:E,5,FALSE)