Hi, im working on a spreadsheet right now and im not sure what im doing wrong. i have the word laborer defined as 45 and when the word laborer is present in a cell i want to multiply that cell by the amount of hours they worked. for example in cell a1 it says laborer, i want to use =product(a1,10) and get the result of 450. does this make any sense? Thanks for your help
Try:
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...
in VBA one can assign a value, but in excel I am not sure
Please Login or Register to view this content.
I Tried that and it came up with #REF! error
okay rcm that worked but can I create a string of if functions? a1 can be several different things; laborer, forman, supervisor, ect
Which sounds like you haven't defined the name accurately.Originally Posted by nickdh47
See the attached workbook for an example of how it does work.
in VBA one can assign a value, but in excel I am not surePlease Login or Register to view this content.
I see what your saying but a1 will not always say laborer it changes depending on what is entered in another cell. I have the name laborer defined as 45 not the cell that its in
How have you 'defined' laborer as 45? Is it a named range?
Might be easier to unpick what you're trying to do if you attach your workbook...
This is starting to sound to me like a lookup table (see the help file for the VLOOKUP() function for an example of a lookup table: https://support.office.com/en-us/art...rs=en-US&ad=US )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks