yogi_Formula In Cell I11 For Cells I11 To I31 To Pull Values From Column W In Sheet Items -- Adding Week(s) If Looked Up Value Is A Number

                 Google Spreadsheet   Post  #1799

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-19-2014

post by  simonjgd:

(https://productforums.google.com/forum/#!mydiscussions/docs/Ktmab8IgN-U)
VLLOOKUP CODE WRONG

This code:

=VLOOKUP(G11,Items!$R$2:$Y$223,6,IF(W2="Y","In Stock",IF(W2=1,"1 Week",IF(W2=2,"2 Weeks",IF(W2=4,"4 Weeks",IF(W2=8,"8 Weeks"))))),false)

gives this:

Error: Wrong number of arguments to VLOOKUP. Expected between 3 and 4 arguments, but got 5 arguments

Can you advise?

Thanks

---

Hi Yogi,

https://docs.google.com/spreadsheets/d/1REORszzugKu6it7nCARa3JoVPAd7CzzkyM2j3MXyTUU/edit?usp=sharing

cell I11.

Using VLOOKUP, I am trying to populate row I with appropriate data from 'Items!W'

-------------------------------------------------------------------------------------------------