| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
