Hi Guys
I posted previously regarding a N/A problem
For one or other reason using vlookup does the following happen
Only the top line display correctly, the rest keeps on showing n/a.
All the info is exactly the same as the top line, if tried actually every solution available but still no success
formula use: =VLOOKUP(B12;Pricelist!A3:B$550;2;FALSE)
I posted previously regarding a N/A problem
For one or other reason using vlookup does the following happen
05581 010 000 | EMPTY ASSORTMENT BOX | R - | 1 | R - |
05581 010 000 | #N/A | #N/A | 1 | #N/A |
05581 010 000 | #N/A | #N/A | 1 | #N/A |
05581 010 000 | #N/A | #N/A | 1 | #N/A |
Only the top line display correctly, the rest keeps on showing n/a.
All the info is exactly the same as the top line, if tried actually every solution available but still no success
formula use: =VLOOKUP(B12;Pricelist!A3:B$550;2;FALSE)