Re: Using VLOOKUP to compare two values

This will very much depend on the data in that sheet option 1

=MID(Sheet2!$C$2,FIND(C2,Sheet2!$C$2,1)+LEN(C2)+26,1)

So I'm trying to find the starting position of the SKU number from sheet1 FIND(C2,Sheet2!$C$2,1) which will gives us the start character of the SKU

Now the SKU number could be different lengths of characters - so I have used LEN(C2) to find the length of the SKU

This is where it can fall down

from the last character of the SKU the quantity amount is 26 characters from the end of the sku - NOW if this is not the same for other examples - this will fail

and so having found the start of the SKU - I then add the length of the sku and add another 26 characters to extract the quantity

we may need to search for quantity if 26 changes - that should be possible

I will add another reply - once played with that

see attached sheet

EDIT

had a play and this should work

=MID(Sheet2!$C$2,FIND("quantity",Sheet2!$C$2,FIND(C2,Sheet2!$C$2,1))+11,1)

see attached V2