Question

rhr9357

New Member
Joined
Feb 24, 2011
Messages
15
I am trying to do the following:if cell # j2 has the text 51525 then find that same text number in column a1:a25 then go three cells to the right and enter the text in that cell in cell # j2.
 
Last edited:

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,890
Office Version
  1. 365
Platform
  1. Windows
Try:
Code:
=IF(J2=51525,VLOOKUP(J2,A1:D25,3,0),"")
 

bryonwoods30

Board Regular
Joined
Feb 24, 2011
Messages
120
also, you can just go to the 3 cells to the right and use the formula

=IF(A:A=$J$2,$J$2,"") and drag it down. if the cell in a matches what is in j2 it will show up, if not then it will be blank.
 

jmthompson

Well-known Member
Joined
Mar 31, 2008
Messages
966
I'm going to rephrase just so I am sure I understand what you want to do, you want to override the value that is in J2 with the value that is in the D column, when it's on the same row where the current J2 value can be found in column A.

This can easily be accomplished with VBA, but I am not sure about a formula
 

bryonwoods30

Board Regular
Joined
Feb 24, 2011
Messages
120
oh yeah sorry i read that wrong. with a formula you can use j2 to look up a value and then replace the value in j2 with a new value, you would just go in a loop.
 

rhr9357

New Member
Joined
Feb 24, 2011
Messages
15
I am not sure I posed the question right. what I want to do is try and find a text number in cells v4:v400 that matches cell # a7. if there is a match then go three cells to the right of that cell # that matches and enter the text in that cell
 

Forum statistics

Threads
1,141,727
Messages
5,708,127
Members
421,548
Latest member
douae

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