Help with Formula
This is a sort of reverse lookup function.
Assuming you have the headers in row 1 and the data start in row 2
=OFFSET(A1,MATCH(D2,B2:B5,0),0)
D2 is the cell where you input the key you are looking for.
Copy this formula down.
Andrea
"juanpablo" wrote:
Thanks I totally forgot about that formula.
One more thing.
If I want to look for '435' in Column B and if found then extract the
correspondent value from column A 'X', and return it, for example, on a cell
C1?
COLUMN A COLUMN B
X 435
Y 719
Z 135
W 524
"Pete_UK" wrote:
Try this formula in C1:
=SUMIF(A1:A10,"1.882.005",B1:B10)
This looks at rows 1 to 10 - adjust the ranges to suit your data.
Hope this helps.
Pete
On Apr 10, 4:00 pm, juanpablo
wrote:
Hi,
I want to create a formula that looks up in column A for example
'1.882.005', if found then add all the data for coulmn B that contains
1.882.005 and put in in cell C1 for example.
COLUMN A COLUMN B
1.882.005 188
1.882.005 27
1.882.005 198
1.882.005 53
1.882.005 47
2.636.119 40
2.636.119 4
3.331.634 4
3.331.634 5
|