More help on VLookup Please

  henbroon6 20:56 23 Nov 2006

VoG™ has helped me before on VLookup but being a bit thick, I still cannot get my head round this.

I have a spreadsheet with approx 12000 product codes in column A and 12350 in column B. I need to know which codes appear in both columns without spending weeks doing it (stock take coming up). A VLookup formula would be very much appreciated.

  VoG II 21:03 23 Nov 2006

Firstly transpose columns A and B.

Then in C2 (I assume that you have text in Row 1)


Then click in C2, hover over the bottom right of the cell until the cursor turns into a + and double click to copy the formula down.

  mammak 21:04 23 Nov 2006

Will be with you shortly.

  mammak 21:05 23 Nov 2006

told you :-)

  henbroon6 21:12 23 Nov 2006

Thank you very much again VoG™ I will try this at work tomorrow.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?