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

  • Thread starter Thread starter RJJ
  • Start date Start date
R

RJJ

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.
 
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
 
Of course if column A is sorted in Ascending order, then you could use the
Vlookup function.
Click to expand...


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

Mike
 
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.
 
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.
 
As responded in your new posting

You could also try index/match ..
In G14:
=IF(G12="","",INDEX(Lists!$C$2:$C$130,MATCH(G12,VendorList,0)))

---
 
Back
Top