I have a table with ID's and Names etc in a sheet and I have another sheet in which I need to enter data using the information in the table in the first sheet, like first name and last name, currency, pay rate etc etc. I am trying to use to Vlookup and Index Match functions but either I get an error or the cell just displays the formula and not the result .
Solved by M. D. in 29 mins