Forum Discussion
Solved
Match names between two sheets and return value of a cell in the row
Hi
I am looking for a way to match a name between two sheets and then return a date value which is in a different cell in the same row.
So in sheet 2 if a site name in coulomb B matches a...
A simple solution using VLOOKUP function is all you need.
Please see the attachment file.
But you have to learn how to use the VLOOKUP correctly and safely!
Here some sources about it:
https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
https://exceljet.net/excel-functions/excel-vlookup-function
A simple solution using VLOOKUP function is all you need.
Please see the attachment file.
But you have to learn how to use the VLOOKUP correctly and safely!
Here some sources about it:
https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
https://exceljet.net/excel-functions/excel-vlookup-function
Thanks this worked perfectly.