Notifications
Clear all
Topic starter
Need help on =VLOOKUP($C7,'Sales Tab'!$F:$CF,'Sales Tab'!AW$7,0) if im putting this formula the value is getting captured from the CELL AX, how?
Posted : 06/08/2018 11:06 pm
Hi Yunus
In your formula VLOOKUP($C7,'Sales Tab'!$F:$CF,'Sales Tab'!AW$7,0), you will need to check what is in cell AW7
It should contain the column index number to extract. Since your formula is extracting from column AX7 I can only assume the value in AW7 is 45.
From your data range F:CF, the column index 1 starts from column F and not column A
You can refer Excel VLOOKUP function explained for more details on VLOOKUP.
Sunny
Posted : 07/08/2018 12:23 am
