Get data from coordinate

Vtookup

Board Regular
Joined
May 30, 2017
Messages
98
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.
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,219
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
May 30, 2017
Messages
98
Hi Norie
I have a hard time inserting the image. anyway I"ll draw
Dec
100ABC
101AAA 300
102-100
103
104200=B104

<tbody>
</tbody>

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
ABC
1AAA
2
3C3=IFERROR(IF(MATCH($A1,Dec!$A:$A,0),"Dec"),"")
4=Dec B104 if greater than zero

<tbody>
</tbody>
Hope you get what i mean.
Thanks
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,893
Messages
5,598,712
Members
414,254
Latest member
MarieCo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top