Inventory Management

Thanks a lot Kostis, Gord & Scott. The VLOOKUP thing gave me hope coz it pulls up data for the next 2 consecutive columns, but for the rest of the columns its comes up with #N/A.

I am not sure as to why this is hapenning. I did look into a web tutorial for vlookup and it was excatly as you guys had mentioned. But, still no go !

I am attaching a sample master sheet of 200 logs from one supplier. PLs havea look and tell me what I am doing wrong. IN the attached excel sheet, GRN No. is the Goods Receipt Note No.

Thanks a lot for all the help u guys are giving me.

Cheers,
Ajit

Hi Newtonboy,

You probably have a solution to this problem now - but in case you don't, here's my suggestion with an attached example using your file.

"=VLOOKUP($A9,'Pine Master Sheet'!$A$9:$V$210,COLUMN(B9),FALSE)"
After being modified for your file, this formula can be copied down as many rows & across as many columns as required.
(See the attached file for more explanation)

The above corrects a slight error in Gord's suggested formula & should stop the "#N/A" problem by adding a dollar sign in front of the lookup reference, ie "$A9" as above. This forces the formula to look up the log id from column A no matter which column the formula is in.
I have also made another change to make it easier for copying the formula across the columns by using the "column" function as shown above. This stops the need for changing the column reference in the vlookup formula when it is copied across the range of columns.

Hth,
Rob Brockett
NZ