# how to get a value from a Row

#### jamiguel77

##### Active Member
Hi friends, i have in cell
A1= 4001
A2= Jhon
A3= Orange

how to get the value of Orange(A3) if i have the value: 4001 (A1)

Thanks

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### DanteAmor

##### Well-known Member
Can be:

=HLOOKUP(4001,A1:A3,3,0)

#### Fluff

##### MrExcel MVP, Moderator
Or maybe =IF(A1=4001,A3,"")

#### jamiguel77

##### Active Member
Worked, what happend is data is:

A1=4001 B1= Jhon C1= Orange

?

thanks

#### Fluff

##### MrExcel MVP, Moderator
Which one worked, you have two alternatives?

#### DanteAmor

##### Well-known Member
=vlookup(4001,a1:c1,3)

thanks

You're welcome

Replies
1
Views
150
Replies
1
Views
83
Replies
4
Views
326
Replies
4
Views
316
Replies
9
Views
146

1,195,632
Messages
6,010,810
Members
441,569
Latest member
PeggyLee

### 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.

### Which adblocker are you using?

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

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