Re: How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 by RJJ
RJJ
Thu May 08 13:04:25 CDT 2008
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" <RJJ@discussions.microsoft.com> wrote in message
> > news:DE7BE576-C09A-44E1-AA14-83495AED3CA3@microsoft.com...
> > > 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.
> >
> >
> >