Showing related tags and posts accross the entire site.
-
Hey all - Geoff here - brand new to the forum and admittedly a novice-intermediate user of Excel (and its Mac cousin - Numbers). In my web search for the solution to my problem, I have already discovered the VLOOKUP and LOOKUP funtions and have it working. Cool stuff, but it does not quite do what I...
-
Here is a typical row in the spreadsheet which is nearly 4000 rows of data: Description WBS WBD Material Qty Mea Size | Ball Valve, V600, 02 | C12DO | F1804B | CARBON STEEL, PIPING | 12 | EA | 1" | Im trying to use the "Description" & "WBS" columns for the criteria to match...
-
I am currently putting together a database of timesheets which contain Name, date, hours (plus others, but these are main ones). I need to lookup into a standing data table two criteria, the name and the date. The standing data consists of name, date of rate change and new rate. Therefore I need to find...