I'm using VLOOKUP function to match tasks (one worksheet) to assets (another worksheet). The key number is "ID" column, which is on both sheets.
I get #N/A error if I use 'Range lookup' =0 or False.
I get wrong data, if the 'Range lookup' is empty.
I have checked many possible error reasons: sorting, length of Lookup value
I've inserted formula in Assets (worksheet) on P2.
I would like top match the whole Tasks worksheet and paste it to Assets.
Anyone can help me with that?