Get data from coordinate

[Vtookup]

Hi
Can anyone help me with a formula to look for the number in a particular coordinate?By getting the number in 4th column, 5th row of $C2
i'm using =IFERROR(IF(MATCH($C2,Dec!$C:$C,0),"confirm",),"") to look for an entry.
can i still use this formula to look for that number? =IFERROR(IF(MATCH($C2,Dec!$C:$C,0),GET THAT NUMBER,),"")
formula should be dynamic $C2 could jump to C8, C14...
Thanks in advance for the help.

 

[Norie]

Try using INDEX.

For example, to get the value from the row in column H.

=IFERROR(INDEX(H:H,C,MATCH($C2,Dec!$C:$C,0)),"")

 

[Vtookup]

Hi Norie
I have a hard time inserting the image. anyway I"ll draw
Dec
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]100[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]AAA[/TD]
[TD] 300[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD][/TD]
[TD]-100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]103[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]104[/TD]
[TD][/TD]
[TD]200[/TD]
[TD]=B104[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I copy this format with 1 row apart. the formula change accordingly
continue copying as many as i need. all spreadsheets are identical
let's just say I have two spreadsheet, dec and jan (revised for this illustration)
Jan will look at dec column A for duplicate name (like AAA) and give back 200 in Jan C4
Jan
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]AAA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]C3=IFERROR(IF(MATCH($A1,Dec!$A:$A,0),"Dec"),"")[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]=Dec B104 if greater than zero[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hope you get what i mean.
Thanks