What is wrong with this formula?
=IF("B2"=GRC_Mapping!$A2:A19,GRC_Mapping!$B2,GRC_Mapping!B2)
I've attached an example spread sheet. Look up value is GRC_Mapping, if column A matches a crossbox is the memotech spreadsheet, I need it to populate a GRC # in the cell directly to the right in column B.
I've attached an example, thank you for taking a look.
Amy
Bookmarks