How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 time
 

How do I create a formula to have cell show the value in C2 or C3 or C4
etc...based on what is in A2 or A3 or A4 etc... EG: If (G12=A2 then C2)...or
if (G12=A3 then C3)...or if (G12=A4 then C4) and so on as many as 30 times.

How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 time
 

One possible way:

=INDIRECT("C"&MATCH(G12,A2:A30,0)+1)

Of course if column A is sorted in Ascending order, then you could use the
Vlookup function.

HTH,
Paul

--

"RJJ" wrote in message
...
How do I create a formula to have cell show the value in C2 or C3 or C4
etc...based on what is in A2 or A3 or A4 etc... EG: If (G12=A2 then
C2)...or
if (G12=A3 then C3)...or if (G12=A4 then C4) and so on as many as 30
times.

How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 time
 

Maybe

=VLOOKUP(G12,A1:C30,3,FALSE)

Mike

"RJJ" wrote:

How do I create a formula to have cell show the value in C2 or C3 or C4
etc...based on what is in A2 or A3 or A4 etc... EG: If (G12=A2 then C2)...or
if (G12=A3 then C3)...or if (G12=A4 then C4) and so on as many as 30 times.

How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30
 

Of course if column A is sorted in Ascending order, then you could use the
Vlookup function.


Only required if using the TRUE switch to look for an approximate match

Mike

"PCLIVE" wrote:

One possible way:

=INDIRECT("C"&MATCH(G12,A2:A30,0)+1)

Of course if column A is sorted in Ascending order, then you could use the
Vlookup function.

HTH,
Paul

--

"RJJ" wrote in message
...
How do I create a formula to have cell show the value in C2 or C3 or C4
etc...based on what is in A2 or A3 or A4 etc... EG: If (G12=A2 then
C2)...or
if (G12=A3 then C3)...or if (G12=A4 then C4) and so on as many as 30
times.

How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30
 

My G12 in the example is actually a selection from a drop down list. What I
need to do is populate other cells with the appropriate data based on the
selection in this drop down list. The appropriate data is on a different
worksheet aligned per row. Hence A3 and C3, A4 and C4 etc.. I am trying using
VLOOKUP but just can't seem to get it to work.

"Mike H" wrote:

Maybe

=VLOOKUP(G12,A1:C30,3,FALSE)

Mike

"RJJ" wrote:

How do I create a formula to have cell show the value in C2 or C3 or C4
etc...based on what is in A2 or A3 or A4 etc... EG: If (G12=A2 then C2)...or
if (G12=A3 then C3)...or if (G12=A4 then C4) and so on as many as 30 times.

How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30
 

Still having trouble.

Column A is (A2:A130), ascending, and is my Vendor list and is named
"VendorList" and resides on a worksheet named "Lists".
Column C (worksheet named "Lists") contains the addresses to the Vendors in
column A and are aligned by rows.
G12, on a worksheet named Purchase Orders, is a drop down list and is tied
to "VendorList" on the worksheet named "Lists".
When I make a selection in G12 (worksheet named "Purchase Orders"), I want
G14 (same worksheet) to display the appropriate address.

I am thankful for all your help.


"Mike H" wrote:

Of course if column A is sorted in Ascending order, then you could use the
Vlookup function.


Only required if using the TRUE switch to look for an approximate match

Mike

"PCLIVE" wrote:

One possible way:

=INDIRECT("C"&MATCH(G12,A2:A30,0)+1)

Of course if column A is sorted in Ascending order, then you could use the
Vlookup function.

HTH,
Paul

--

"RJJ" wrote in message
...
How do I create a formula to have cell show the value in C2 or C3 or C4
etc...based on what is in A2 or A3 or A4 etc... EG: If (G12=A2 then
C2)...or
if (G12=A3 then C3)...or if (G12=A4 then C4) and so on as many as 30
times.

How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30
 

As responded in your new posting

You could also try index/match ..
In G14:
=IF(G12="","",INDEX(Lists!$C$2:$C$130,MATCH(G12,Ve ndorList,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30
 

Thank You! This worked perfectly.

"Max" wrote:

As responded in your new posting

You could also try index/match ..
In G14:
=IF(G12="","",INDEX(Lists!$C$2:$C$130,MATCH(G12,Ve ndorList,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30
 

Welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RJJ" wrote in message
...
Thank You! This worked perfectly.