# Tag Info

## New answers tagged lookup

1

Here's a simple formula: =SUMIFS(C:C,A:A,G1,B:B,G2) Put the User ID into G1, and put the Item ID into G2 (or change the formula to suit your needs). This formula will sum C columns values of all the rows where the User ID and Item ID match. Hopefully there will be only one possible cost. If there's duplicates, it will give you the sum of the duplicates! ...

0

H1=COUNTIF(OFFSET(Sheet2!\$A\$1,MATCH(G1,Sheet2!C:C,0)-1,0,50),"FindMe") filled down column H This will Grab the corresponding value in column G find the row that has that value in column C of Sheet2. Count the number of times "FindMe" appears in that row. The 50 is how many columns to search. Change the \$A\$1 to \$J\$1 or whatever column you want to start ...

2

When you enter =CELL("contents",ADDRESS(1,2)) you are expecting Excel to evaluate that expression to =CELL("contents",\$B\$1). This isn't quite what Excel does. Excel will read it as =CELL("contents","\$B\$1"). Note the quotes - Excel thinks this is a string, not a cell reference. This is why you get an error. To convert the string output of ADDRESS() to a ...

Top 50 recent answers are included