Hello again,
This time I am trying to get the cost and weight to autofill on sheet2. Is this too complex to make happen?
Thanks in advance!
Aub
Hello again,
This time I am trying to get the cost and weight to autofill on sheet2. Is this too complex to make happen?
Thanks in advance!
Aub
Hi
Sheet2:
D2: =VLOOKUP(C2,OFFSET(INDIRECT(B2),0,0,,3),2,FALSE)
E2: =VLOOKUP(C2,OFFSET(INDIRECT(B2),0,0,,3),3,FALSE)
copy down as required.
rylo
I figured it out, used IFERROR in column E and F, and IF in G and H... that seemed to clean it up
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks