LinkBack URL
About LinkBacks
Dear all
Have no idea why the Vlookup is not working ..
Kindly advise, in the attached file
SIC_ADult and SIC Child , return with a wrong figure
Appreciate your help
Eric
Dear all
Have no idea why the Vlookup is not working ..
Kindly advise, in the attached file
SIC_ADult and SIC Child , return with a wrong figure
Appreciate your help
Eric
Try ...
=VLOOKUP($D9,Net!$A$1:$P$142,11,0)
Add the part in red below:
Formula:
Please Login or Register to view this content.
And amend the column number from 11 to 15
BSB
Last edited by BadlySpelledBuoy; 06-30-2016 at 08:56 AM.
Hi Eric,
Your VLOOKUP is looking at Column K of the Net Sheet.
Change the "11" in your formula to a "16".
Please Login or Register to view this content.Hope this is helpful.Please Login or Register to view this content.
Cheers
Use a similar formula to the one which is already in Column G:
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks but it is still not working
In what way is it "not working"? That doesn't give us much information.
BSB
Have a look at the amended attachment.
BSB
Dear, it works, how come ?!
Hi
Did you get it fixed by now?
Hi
Works for me ok but just replacing the formula with the correct cell reference: =VLOOKUP($D9;Net!$A$1:$P$142;15;FALSE) 15 instead of 11 for SIC_ADT and 16 of 12 for SIC_CHD
What else doesn't work?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks