Hi Gaveon,
Try adding a new column that multiplies your value by 1.
So the Formula for a value in 'A2' would be;
=A2*1
This will convert it into a number.
Do this to both & the VLOOKUP should work.
Hth
Hi Gaveon,
Try adding a new column that multiplies your value by 1.
So the Formula for a value in 'A2' would be;
=A2*1
This will convert it into a number.
Do this to both & the VLOOKUP should work.
Hth
Remember you are unique, like everyone else
That did the trick.
Thankyou very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks