I am working on a sheet with the following:
Sheet 1 Col A = Description
Sheet 1 Col B = ID
Sheet 1 Col C = Returned value from Sheet 2 Col B when value in Sheet 1 Col B matches value in Sheet 2 Col A
I would like to take a cell from Sheet 1 Col B and find the matching value in Sheet 2 Col A and fill in Sheet 1 Col C with associated value from Sheet 2 Col B.
I know this is a simple lookup but I can't get it to work.
Bookmarks